Code Forums - View Single Post

sde · 08-22-2004, 07:45 AM

try this:

Code:

select * from listings where 1 order by city asc, price desc

i haven't tested it, but i'm pretty sure that query will work with mysql.

08-22-2004, 07:45 AM	#2 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,505	try this: Code: select * from listings where 1 order by city asc, price desc i haven't tested it, but i'm pretty sure that query will work with mysql. __________________ Mike Last edited by sde; 08-22-2004 at 02:28 PM.