Seguro es facil asi
Código PHP:
$sql = "SELECT COUNT( * ) AS `Filas` , `IP`
FROM `table_log`
GROUP BY `IP `
ORDER BY `IP` DESC
LIMIT 0 , 10";
$r = mysql_query($sql) or die(mysql_error());
echo "Top ten IP";
while($row = mysql_fetch_assoc($r)){
echo $row["IP"] . " = " . $row["Filas"]."<br />";
}
Perdona que no fuera especifico anteriormente.