Order by and MySQL

[Anon]

I am trying to pull the data from a table called COMMENTS, I want to get the highest id first, then the last.

If i use:

$result = mysql_query("SELECT * FROM COMMENTS order by id LIMIT $count,12", $db);

while($row= mysql_fetch_array($result))
{
print "id = $row[id]";
}

I get the results

id = 1
id = 2
etc...

How do I tell SQL to pull the items

id = 3
id= 2
id= 1

[Anon]

Have you tried putting an "ASC or DESC" after the ORDER BY??? I am not extremely familiar with mySQL by in SQL Server 7.0 you would do something like this....

$result = mysql_query("SELECT * FROM COMMENTS order by id DESC. ... .etc

That SHOULD work-

[Anon]

As grubsy pointed out, ORDER BY id DESC will work..

[Anon]

Don't you think they would put something like this in the manual at www.mysql.com?

[Anon]

It is in the manual, you just have to know enough to know how to find the commands that you do not know... damned confuzzling manual if ya ask me... one of these days I really need to get around to writing all these much needed items into a nice set of tutorials so I can help newbies get past all those little pitfalls that I got stuck in, that and so I don't go forgetting all this stuff myself... 🙂