pugs1501 Posted April 11, 2007 Share Posted April 11, 2007 I am trying to figure out a php script to sort mysql results using two columns to sort on like you can do in excel. it is kinda like a dual sort. when you can sort on data in column 1 and in column 2 so they can be easier to find instead of sorting by one column and then hoping you entered them in to the database alphabetically. I have a database with locker number and combos but the locker number is in two columns one for the flour it is on and one for the number on that floor. I am hoping to be able to sort so the floor number and the locker number are both in chronological order. Thank you in advance for all your help. Quote Link to comment https://forums.phpfreaks.com/topic/46624-solved-how-to-sort-a-mysql-database-on-you-differnet-columns/ Share on other sites More sharing options...
pikemsu28 Posted April 11, 2007 Share Posted April 11, 2007 $sql = "Select * from {table} ORDER BY {column1}, {column2}"; Quote Link to comment https://forums.phpfreaks.com/topic/46624-solved-how-to-sort-a-mysql-database-on-you-differnet-columns/#findComment-227020 Share on other sites More sharing options...
pugs1501 Posted April 13, 2007 Author Share Posted April 13, 2007 Thank you very much it worked wonderfully for what I needed it for. Quote Link to comment https://forums.phpfreaks.com/topic/46624-solved-how-to-sort-a-mysql-database-on-you-differnet-columns/#findComment-228476 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.