Struggling with a summary count by name

[phplearner]

I have a table with the following columns:

ID
refip
refname
refdate

All I want to do is to display a summary of the 'refname' entries with the total number of entries for each.

Like:

nameA = 3
nameB = 7
nameC = 2

Here is my SQL query:

$result = mysql_query("SELECT refname, COUNT(refname) AS subtotal FROM cc_refsource GROUP BY refname",$db) or die(mysql_error());

I get only 3 names showing which is great, but no totals for each.

A further snippet:

while ($row = mysql_fetch_array($result)) {
echo "$row['refname']";
echo "$row['subtotal'];
}

Any help is appreciated. Thanks.

[LordShryku]

Suprised you don't get a parse error. You're missing the last double quote in your echo statement(echo "$row['subtotal']😉

Just a side-note...the double quotes are unneccesary. Just
echo $row['refname'];
echo $row['subtotal'];
would work...

[phplearner]

Hey thanks. I retyped part of the stuff into the post, but found a missing ">" in one of the <td>$blah</td> lines. I need new glasses.

Actually, I tried about 20 different combinations of things, and have discovered that COUNT(ID) produces the same results.

I appreciated your response, LordShryku.

Now, on to the next challenge here :rolleyes: