dweb Posted June 30, 2013 Share Posted June 30, 2013 Hi all I have the following database table ID NAME 1 David 2 John 3 Vicky 4 Rob 5 Suzzie and I run the following Query SELECT * FROM `staff` ORDER BY `name` ASC LIMIT 4 Which is cool and works great I want to keep my Query as it is, but I want to sort the output by the ID So it keeps the ORDER BY `name` ASC but the actual sorting is by `id` ASC Can that be done? Thanx Quote Link to comment https://forums.phpfreaks.com/topic/279736-sort-by-diffferent-to-order-by/ Share on other sites More sharing options...
Barand Posted June 30, 2013 Share Posted June 30, 2013 No. If you want it sorted by id use ... ORDER BY id Quote Link to comment https://forums.phpfreaks.com/topic/279736-sort-by-diffferent-to-order-by/#findComment-1438729 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.