[SOLVED] Sort by more than one field..?

[PHPNewbie55]

Is there any way to sort by more than one field..??

 

<?php

mysql_query("SELECT * FROM table_name ORDER BY field 1 and field 2")

?>

[p2grace]

Try this:

 

 

mysql_query("SELECT * FROM table_name ORDER BY `field1`,`field2`");

[papaface]

SELECT column_name(s)
FROM table_name
ORDER BY column_name1, column_name2

[PHPNewbie55]

Cool that works...  Now I onlyhave one more question before I start my day and recode a bunch of stuff......

 

THANK YOU!