Re: Select Count(Distinct <fieldname>) from <table>...

[bert hubert]

On Sat, 13 Mar 1999, Hank Eskin wrote:

> The only solution I have used to do this is issue:
>   SELECT <fieldname>, count(*) from <tablename> GROUP BY
> <fieldname>;
> and then get the mysql_NUMROWS (using PHP3).
> 
>  So, is there a way, in one simple query to return this value?

Not yet. I've offered Monty to code it in, but he requested that I wait
for improvements in MySQL making the implementation easier.

A Quick Hack might be possible though. But all it would do is implement
the mysql_numrows trick, discarding the table generated.

regards,
bert hubert.