I've got this query which groups a number of values together (ip_address) but I also need to know how many grouped values there are.
$result = mysql_query("SELECT ip_address, COUNT(*) AS count FROM unique_views GROUP BY ip_address ORDER BY count DESC");
$myrow = mysql_fetch_array($result);
Can anyone help me out please?