Drezard Posted April 29, 2007 Share Posted April 29, 2007 Whats wrong with this query: SELECT from, subject, message, time FROM user_messages WHERE username='$username' ORDER BY timestamp DESC I get this 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 'from, subject, message, time FROM user_messages WHERE username='Drezard' ORDER B' at line 1 Cheers, Daniel Link to comment https://forums.phpfreaks.com/topic/49178-mysql-query-problems/ Share on other sites More sharing options...
tauchai83 Posted April 29, 2007 Share Posted April 29, 2007 please post all your query code. Thank you. Link to comment https://forums.phpfreaks.com/topic/49178-mysql-query-problems/#findComment-240971 Share on other sites More sharing options...
tauchai83 Posted April 29, 2007 Share Posted April 29, 2007 before that, please change your FROM field to another name, for eg, froms. It could be a reserved word for mysql. Thank you. Keep on trying ya. post your whole sql code here. Link to comment https://forums.phpfreaks.com/topic/49178-mysql-query-problems/#findComment-240974 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.