Hello,
I am pulling stuff from the db like so
$sql = mysql_query("SELECT * FROM tkts WHERE game_id='$game_id' AND status='open' order by area asc");
however I want it to sort first by: section
then by row
then by seat
how would I do this?
Many Thanks
Chris
ORDER BY {unsigned_integer | col_name | formula} [ ASC | DESC ] ,...
SELECT * FROM tkts WHERE game_id='$game_id' AND status='open' ORDER BY section asc, row asc, seat asc
Or something like that.
Perfect !!
many Thanks Chris
