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

Reply via email to