MrAdam Posted September 17, 2007 Share Posted September 17, 2007 by default the results returned from an sql query are selected from the start of the database, to the end. If that makes sense? .. Basically the results are returned ASC by default?Can you change the query to select from the end of the database to the start, so they are effectively ordered DESC? (Without having to specify a field to order by)If not, I think i may face a problem.... see i created a website quite a while ago that has products in the database and a unique ID that isn't incremental, the owner uses his own ordering system. So I cannot make the query like:"SELECT..........ORDER BY id DESC"if i want to select the last 5 entries.... could anyone think of a way of doing it? anyway i could alter the table or anything?- Cheeerrs! Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.