RE: Select statement driving me crazy

[Mike Hillyer]

Try wrapping all column anmes in back-ticks (i.e. SELECT `date`) and see
if that works.

Mike Hillyer
www.vbmysql.com


-----Original Message-----
From: Anthony Ward [mailto:awards@stripped] 
Sent: Tuesday, May 27, 2003 9:03 AM
To: mysql@stripped
Subject: Re: Select statement driving me crazy


Hi,

forgot to mention, the names are not misspelled, and i got rid of all
indexes, primary etc...
before with primary key it was NOT working without index it still NOT
working.

And i use the same code, for different table, with different name, so i
just
changed the name and now everyhting is working but for the other table
only.
Can it be in the configuration of the table??


Now if i  take the query that is not working, and instead of picking
columns
i use *
 it is working.
Now if i put instead the * all the columns name(not misspelled) nothing
is
working

AnthonyW.






-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1