mysql query results sorting
Posted
by user329094
on Stack Overflow
See other posts from Stack Overflow
or by user329094
Published on 2010-06-16T15:52:14Z
Indexed on
2010/06/16
15:52 UTC
Read the original article
Hit count: 163
I am calling the results form a query to a list on my site based on if the item is "downtown_hosted". This works fine but I would now like to sort that list DESC, but can't seem to get the syntax correct.
Below is what I have:
$result_events = mysql_query("SELECT * FROM events WHERE downtown='downtown_hosted' ORDER BY date DESC LIMIT 5 ");
© Stack Overflow or respective owner
