i have two fields in a table, age and name.
Is it possible, via a mysql_query to order the list by age descending, then name ascending.
eg.
Name - Age
Andrew - 20 Bernie - 20 Chriss - 20 Andrea - 18 Bertie - 18 Christ - 18
Yes. Select name, age from <table_name> order by age desc, name asc;
Hank
oh.. that easy :-) thanks very much