[Resolved] a 2nd "order by" command to sort lists

[pheagey]

Ok, I have files listed by 'author', but from there I want the files sorted by 'date'. Here's the PHP line I have for the 'author' sorting:
$sql = "SELECT * FROM dl_links WHERE categoryid=$catID AND approved=1 ORDER BY author ";

I'd like something like:
$sql = "SELECT * FROM dl_links WHERE categoryid=$catID AND approved=1 ORDER BY author THEN ORDER BY 'date'";

any ideas/help is greatly appriciated

[barand]

$sql = "SELECT * FROM dl_links WHERE categoryid=$catID AND approved=1 ORDER BY author, date";

hth

[pheagey]

thanks man. Im not very learned on SQL. Imjust getting into it..