Counting unique records?? [cont..]

[Anon]

someone asked for the code..

<?
$db = mysql_connect("localhost","root");
mysql_select_db("test",$db);
$result = mysql_query("SELECT referrer, COUNT(referrer) FROM links GROUP BY referrer DESC",$db);
$row = mysql_fetch_array($result);
$count = mysql_num_rows($result);

$i = 0;
while($i != $count)
{

	$reff = mysql_result($result,$i,"referrer");
	echo "$reff <br>";
	$i++;
}

?>

it only shows up like this

[name]
jaret
mike
james
bob

and not like this
[name]--------[number]
jaret-------------3
mike--------------2
james-------------4
bob---------------1

[mrskhris]

What are you expecting?
$reff contains the value of referer field... and only. You need to fetch the value of count() as well and the print it out.

[Anon]

yea, but how do i get count?

that is where i am stuck

[Anon]

on your mySQL select statement
include this:
COUNT(referrer) as counter

then print the value of counter like
echo $row["counter"];