[SOLVED] sql syntax error (basic question)

[billy61]

im running this query:

$query     = "SELECT * FROM articles LIMIT 8 ORDER BY id DESC";
$dbquery   = mysql_query($query)
	or die('Could not query :<br/>' . mysql_errno() . " : " . mysql_error());

 

and getting this error:

 Could not query :
1064 : 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 'ORDER BY id DESC' at line 1

every mysql and php reference i can find on the web uses this same syntax, but for me its returning this error.

 

can anyone help me?

[AndyB]

$query    = "SELECT * FROM articles ORDER BY id DESC LIMIT 8 ";

[billy61]

thank you, that fixed things up.

 

previously, i was using this page:

http://www.phpfreaks.com/mysqlref/8.php

as an example, and there are some inaccuracies on that page as some of the examples have the LIMIT in front of the ORDER BY.