shorting (quick help)

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
spamyboy
Forum Contributor
Posts: 266
Joined: Sun Nov 06, 2005 11:29 am
Location: Lithuania, vilnius

shorting (quick help)

Post 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 ? :|
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: shorting (quick help)

Post by Christopher »

Code: Select all

SELECT * FROM games $sql_filter ORDER BY love DESC, id DESC LIMIT $from, $max_results
(#10850)
Post Reply