How many unique entries?

cakkafracle

I wish to count and capture the value of UNIQUE entries in a field.

For example:

TABLE(GALLERY) has a field called CATEGORY.

What I have is this:

$result = mysql_query("SELECT CATEGORY FROM GALLERY");
$numrows ($result);

for($i=0;$i<$numrows;$i++){
   $category[$i] = mysql_result($result,$i,'CATEGORY');
}

now I have an array that holds every Category entry.
What I want is to remove ALL DUPLICATE entries, so if I only have 7 different Category names, I'm left with only 7 elements in my Array

tips anyone?

Cakk

savvas

SELECT DISTINCT t.category FROM t

should give you a column with all unique values in that column

cakkafracle

aaaah, DISTINCT! how obvious once ya see it.

thanks man

mogster

Ehm...
This query look a bit quirky, but I'll give it a shot:

Use distinct to pick only one of each value from the table-field.

$result = mysql_query("SELECT distinct CATEGORY FROM GALLERY");
$dCats = mysql_fetch_array($result);
## Now count ##
$num_dCats = count($dCats);
echo $num_dCats."<br>";
## Loop to print catnames ##
for($i=0;$i<$num_dCats;$i++) {
echo $dCats[$i]."<br>";
}

I think 😃

knutm