[SOLVED] You have an error in your SQL syntax
Posted: Sat Jul 31, 2004 10:51 am
Hi there, I've read the sticky forum post and tried the suggestions before asking this question, but 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 'lines ORDER BY id DESC' at line 1
at this line of code:
I'm a bit lost now, I just can't see what I've done wrong. $dbname variable is the correct database and lines is the correct table.
Too strange, I'd really appreciate any suggestions.
Thanks
Rob
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 'lines ORDER BY id DESC' at line 1
at this line of code:
Code: Select all
$result = mysql_db_query($dbname, "SELECT * FROM lines ORDER BY id DESC") or die(mysql_error());Too strange, I'd really appreciate any suggestions.
Thanks
Rob