Page 1 of 1

Quick SQL Question

Posted: Thu Aug 17, 2006 8:55 pm
by ibanez270dx
Hi,
I was wondering how I would be able to reverse the order of an SQL select... For example, if you select stuff from your table and order by the ID number, then it will go from smallest to largest (I.E. 0 - 100). How can I reverse that to make it order from largest to smallest?

Thanks,
- Jeff
[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:1. Select the correct board for your query. Take some time to read the guidelines in the sticky topic.

Posted: Thu Aug 17, 2006 8:57 pm
by klarinetking
Hi,

Add on 'ORDER BY `fieldname` ASC/DESC'

klarinetking

Posted: Thu Aug 17, 2006 9:09 pm
by ibanez270dx
thanks!