[SOLVED] how to sort a mysql database on you differnet columns.

[pugs1501]

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.

[pikemsu28]

$sql = "Select * from {table} ORDER BY {column1}, {column2}";

[pugs1501]

Thank you very much it worked wonderfully for what I needed it for.