Help with a query

[mike1313]

How would I properly use ORDER By in this statement?

 

$sql = "SELECT message_id, user_name, message, date_format(post_time, '%h:%i') as post_time" .

" FROM message WHERE cn_id = " . db_input($_GET['cn']) . " AND message_id > " . $last;

 

[xyn]

Can you explain more about your "order"

try explaining it a bit more of what you are trying to do.

[mike1313]

I want to display the last 20 rows and ORDER BY message_id how would I do this?

[xyn]

mysql_query("select * from `table` ORDER BY `message_id` DESC Limit 0,20")

[mike1313]

I know that much but I want to change as little as possible in my current statement.

[xyn]

ORDER BY `message_id` DESC Limit 0,20

 

use that at the end of your query then...