Finally got it! Cheers for all your help... it was the group by Emial that was the clincher... I didn't know that it acted like distinct() Live and learn...! Cheers everyone! "Gavin Amm" <Gavin@xxxxxxxxxx> 04/06/2004 00:16 To <php-db@xxxxxxxxxxxxx> cc Subject RE: Multiple SQL queries...? Have you tried - GROUP BY email - ? > Nope... > HHmmm, this is really getting to me... > I can do distinct, I can count, but I can't combine the two? > Can't be that hard ;-) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
