Page 1 of 1

shorting (quick help)

Posted: Wed Jan 24, 2007 7:40 pm
by spamyboy

Code: Select all

SELECT * FROM games $sql_filter ORDER BY love, id DESC LIMIT $from, $max_results
here is my curent query, it should list 1st by love DESC and then by ID DESC, but it first list by ID, how to make it list first by LOVE and only then by ID ? :|

Re: shorting (quick help)

Posted: Wed Jan 24, 2007 8:13 pm
by Christopher

Code: Select all

SELECT * FROM games $sql_filter ORDER BY love DESC, id DESC LIMIT $from, $max_results