like this:
Look, I am not sure, ok.
SELECT COUNT(SELECT DISTINCT EMAIL, COUNT(*) AS total FROM mytable GROUP BY EMAIL) FROM mytable
Don't you have any solution that I could get this result with phpmyadmin instead of using a php script to get it.
Thanks
Rod