[SOLVED] echoing sql error, but cannot see anything

[PC Nerd]

hi guys....

ive been working on this script, and it was working fine.... however ive added a condition to my SQL, and its stopped working.  im 90% sure the syntax is correct, and i know the values are echoing out fine.....heres the code:

 

$Ind_Messages_SQL = "SELECT * FROM individual_messages WHERE (User_ID = '".$Page_Data['User_ID']."') or (To = '".$Page_Data['User_Name']."')";

 

my output is here:

SELECT * FROM individual_messages WHERE (User_ID = 'correct user_ID') or (To = 'correct_user')

 

and the error:

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'To = 'correct_username')' at line 1

 

if anyone can spot the error, id be most greatful

 

thanks

[paul2463]

Hi PC Nerd your problem is that TO is a reserved word in mysql try this one

 

$Ind_Messages_SQL = "SELECT * FROM individual_messages WHERE (User_ID = '".$Page_Data['User_ID']."') or (`To` = '".$Page_Data['User_Name']."')";

 

Regards

Paul

[AndyB]

to is a reserved word - http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

 

Avoid using reserved words as column/field names or table names.

[PC Nerd]

thanks

 

working

 

 

c y a