major brain fart....

Ok, mysql question....

How can I get mysql to look at a certain field in a database and do the following:

1). find distinct records in a certain field
2). Count those distinct records.

I know how to do the count, and how to do the distinct, but not both at the same time?

thanks for all your help

select COUNT(distinct(yourfieldhere)) from yourtable

<?php
$result = mysql_query("SELECT DISTINCT stuff FROM other_stuff",$link);

$num_rows = mysql_num_rows($result);
echo "$num_rows";
?>

Is that what your wanting? 😕

That works too. I just prefer to have the database do the majority of the work. Seems more efficient that way.

Originally posted by ereptur
That works too. I just prefer to have the database do the majority of the work. Seems more efficient that way.

yea, but in this case he said

but not both at the same time

😉 🙂

Originally posted by jebster
yea, but in this case he said
quote: but not both at the same time

😉 🙂

In other words, toddmarx didn't know/couldn't recall how to combine them. ereptur's code shows how.

Oops, guess I read it wrong. Thought he said both at the same time

I got it guys/gals/whatevers(you never know this day and age, you have to CYA 🆒 )

Thanks for your help.😃