Could I use two selections to solve it?

wxdqz

New Member
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
 
Back
Top