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" <[EMAIL PROTECTED]> 04/06/2004 00:16 To <[EMAIL PROTECTED]> cc Subject RE: [PHP-DB] 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