Hi,
I have a table that contains some words and their translation, in various languages. I would like to select the translations for a particular language but use the English word in case their ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
mysql> describe atf;
+----------------+--------------+------+-----+---------+----------------+
| Field
| customer_id | int(11) | NO | PRI | NULL | auto_increment |
| date ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Does mysql have a count function where ...? I want to count the number of rows mysql returns where something is equal to something. What's the fastest way to do this? (I'm using php + mysql)
T...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
basic question: i'm trying to grab info from one table and sort by a value in the nested query -- below is the background and code:
i'm developing a photo upload site. I give the user the abil...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi
I have the following DB structure
Code:
charges
cID [bigint]
cpID [bigint]
amount [decimal 3,2]
date_charge [datetime]
petition...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi,
im tryn to run a sql query but im getting this error
Code:
SQL query:
CREATE TABLE `font` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 255 ) NOT NULL ,
`font_url...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Yet again I have a query about joins and even though I keep reading I cannot find a solution for my problem that is relevant or that I understand.
I have 3 tables (I have shortened the number of f...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am trying to create a system where a user can enter their registration number (uk cars) and have our site tell them what parts (we sell towbars and such) are compatible with their car.
I have ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Is there a single query I can run that will set all values of a single column to 0, but set some values to 1 ?
somthing like
Code:
UPDATE `table`
SET `column_name` = 0
WHERE `row_id...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Is column = column + 0 allowed as part of a MySQL query?
I am experiencing problems using it, but I can't be sure if it is that or something else in the code..
Cheers
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I've got a table named "selector" with the following fields:
model
make
year
timestamp
I'm trying to write a query that returns the number of times that a unique model, mak...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hiya,
I'm writing a quick script in PHP to update user details that have already been submitted, but for some reason I can't get the following code to update the DB
PHP Code:
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I'm using the following code to import a .sql file.
Code:
mysqlimport --local -u root -pCENSORED teraspot_db /home/default/teraspot_db.sql
and I get this error
Code:
my...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Ok all i'm trying to do it left join a table on another and order by the data in the joined table. Meaning that since it's left joined there is the possability that there will be no data in that t...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi there,
I have to make a system for my final year uni project. To put it simply i have 3 tables.
1.) School
2.) Class
3.) Student
Obviously Schools have classes and each class ha...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
GROUP_CONCAT is a great function...But have MySQL version < 4.1 and my hosting provider can't upgrade MySQL. Is there a way to get this result with a different SELECT query?
I have a list o...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi everyone, the problem is in next:
I have table with following fields:
PointsID int(10)
UserID int(10)
ProductID int(11)
Reason tinyint(4)
Date datetime
Points va...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am having problems with my character set - and as a result, certain characters get converted. I changed the column collation to "utf8_general_ci", but it didn't work.
When I use ph...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello Everyone.
Everytime I try to read from any MySql database in PHP, I get a blank screen or just a blank response.
I dunno what the problem is. is it the configuration?
When i use ph...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello!
I am using php4 and mysql and running them in IIS. I installed all in C:\.
Then I put phpmyadmin folder into the wwwroot folder. When I login http://www.mysite/phpmyadmin [http://www....
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi guys im trying to take off my live database and overwrite it upon my local version of my site on my desktop computer. I have not too much of an idea what im doing - what would be the best way?
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
HI, im following a book to learn sql, its a very good one by larry ullman ( sorry sitepoint!) but its got me a lttle confused. Its told me to create a table that includes a column caled url_id tha...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am trying to figure out why I have a hugely slow query (~2 seconds in my testing environment). Details are below:
It involves two tables, products and vendors.
Products is a huge tabl...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have these queries:
Code:
SELECT
COUNT(s01_Products.id)
FROM
s01_Products
LEFT JOIN
s01_Attributes
ON
s01_Attributes.product_id = s01_Products.id
LEFT JOIN
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi All
I need to search my whole database and update a word to add ™ to it.
Any ideas on how this is done?
Any help would be great.
Many Thanks
mrmbarnes
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
