Include mysql numrows

[unemployment]

How do I find the count of mysql num rows and output that value with this function?

 

function fetch_company_fans($cid)
{
$cid = (int)$cid;

$sql = "stuff";

$result = mysql_query($sql);

$fans = array();

while (($row = mysql_fetch_assoc($result)) !== false)
{
	$fans[] = array(
		'username'			=> $row['username'],
	);
}

return $fans;
}

[dcro2]

$result = mysql_query($sql);
if($result) echo "Rows found: ".mysql_num_rows($result);