Page 1 of 1

mysql (quick query help)

Posted: Sun Jan 21, 2007 3:28 pm
by spamyboy

Code: Select all

$result = mysql_query("SELECT * FROM games $sql_filter ORDER BY id DESC AND love DESC LIMIT $from, $max_results");
I want to order by to options at time, ID & love (love is number of hits)

Posted: Sun Jan 21, 2007 3:30 pm
by feyd
SQL (query) questions goes in Databases, not PHP - Code.

ORDER BY clauses use comma separations to distinguish between decision algorithms.

Posted: Sun Jan 21, 2007 3:37 pm
by spamyboy
Thank you.