TalkPHP - View Single Post

freenity · 04-17-2008, 01:07 AM

[CODE=SQL]
SELECT category.id
FROM category, details
WHERE category.id = details.category
ORDER BY category.id DESC;
[/code]

just add order by `field` desc; or asc for ascending order. ;)

04-17-2008, 01:07 AM	#5 (permalink)
freenity The Acquainted Join Date: Feb 2008 Posts: 119 Thanks: 17	[CODE=SQL] SELECT category.id FROM category, details WHERE category.id = details.category ORDER BY category.id DESC; [/code] just add order by `field` desc; or asc for ascending order. ;) __________________ http://feudal-times.net - My PBB Game http://gwphp.feudal-times.net - My Blog "Gaming With PHP" Last edited by freenity : 04-17-2008 at 07:10 PM.