> $result = mysql_query("SELECT * FROM pfiles WHERE cdate >= '2002-07-01' > ORDER BY 'cdate' DESC", $link); > > I would like to be able to sort this data FIRST by 'cdate' then by 'vendor' > Is this possible?
Yes. Just add another sort criterium to your query like this: $result = mysql_query("SELECT * FROM pfiles WHERE cdate >= '2002-07-01' ORDER BY 'cdate' DESC, 'vendor' DESC", $link); Petr. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php