> $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
