Thread: Problem in function?
View Single Post
  #6 (permalink)  
Old 02-09-04, 12:27 AM
nd2 nd2 is offline
Wannabe Coder
  
Join Date: Jun 2003
Posts: 128
Thanks: 0
Thanked 0 Times in 0 Posts
you will find that read is actualy a mysql reserved word.
there is however a way arround it by simply placing backticks arround the table name which are normal not required.

SELECT * FROM messages WHERE `read`='no'
__________________
IonCMS (Coming Soon.)
http://ioncms.com
--
Ncaster (Free php/mysql cms)
http://ncaster.cjb.net
Reply With Quote