ORDER BY one column then another

Hi,

I am trying to retreive ordered data from a mysql database using the following query.

"SELECT * FROM $table ORDER BY location"

I have been ordering the data by 'location' only. However I now want to also order the data by 'customer_name' within the location.

Is this possible in a mysql query?
Any help would be appreciated,

Thanks

James

Just put

SELECT * FROM $table ORDER BY location,customer_name

and put ASC or DESC beside each for ascending or descending order.

Thanks, I'll give it a go.