"Angelo Zanetti" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > select thename, count(thename) from <tablename> order by thename asc group > by thename
or... to sort by number of records select name, count(name) as ncnt from table group by name order by ncnt desc -- Rob -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
