mySQL ORDER BY?

[jodeleeuw]

Is it possible to order by one field, then another?

For example, I know that in my database if I tell it to order by $recording_company there will be 15+ albums of the same recording company. Can I tell it that once its ordered by recording compnay, that it should then order by album name?

[jcornett]

Sure, just use this syntax:

SELECT * from <table name> ORDER BY <field 1>, <field 2>, <field 3>

John Cornett

[jodeleeuw]

Thanks!!