waarschijnlijk simpel.. optellen

 213.204.221.63 lottery notification 
 82.134.132.172 medicine/drugs Cialis Softtajl 
 82.134.132.231 medicine/drugs it was you! 
 82.134.132.79 porn Re: Or believe my insecure stirrup Ref # [1M86j... 
 82.134.132.79 medicine/drugs Your doctor called Ref # [1M86U34xlc1ARsj] 
 82.134.134.152 medicine/drugs One-dollar ClALlS 
 82.134.134.152 medicine/drugs One-dollar ClALlS 
 82.134.134.152 scam Small Cap For You to Watch 

213.204.221.63 lottery notification 
 82.134.132.172 medicine/drugs Cialis Softtajl 
 82.134.132.231 medicine/drugs it was you! 
 82.134.132.79 porn Re: Or believe my insecure stirrup Ref # [1M86j... 
 82.134.132.79 medicine/drugs Your doctor called Ref # [1M86U34xlc1ARsj] 
 82.134.134.152 medicine/drugs One-dollar ClALlS 
 82.134.134.152 medicine/drugs One-dollar ClALlS 
 82.134.134.152 scam Small Cap For You to Watch

<?
$array = array (1, "hello", 1, "world", "hello");
print_r(array_count_values ($array));
?>

De output van bovenstaand programma ziet er zo uit:

Array
(
    [1] => 2
    [hello] => 2
    [world] => 1
)

<?
$array = array (1, "hello", 1, "world", "hello");
print_r(array_count_values ($array));
?>
 
De output van bovenstaand programma ziet er zo uit:
 
Array
(
    [1] => 2
    [hello] => 2
    [world] => 1
)

CREATE TABLE `reports` (
  `rid` int(11) NOT NULL auto_increment,
  `ipaddress` varchar(16) NOT NULL default '',
  `type` enum('spam','virii','trojan','portscan','attack','intrusion','relay','other') NOT NULL default 'spam',
  `subject` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `date` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`rid`),
  FULLTEXT KEY `subject` (`subject`),
  FULLTEXT KEY `description` (`description`),
  FULLTEXT KEY `ipaddress` (`ipaddress`)
) TYPE=MyISAM AUTO_INCREMENT=129 ;

CREATE TABLE `reports` (
  `rid` int(11) NOT NULL auto_increment,
  `ipaddress` varchar(16) NOT NULL default '',
  `type` enum('spam','virii','trojan','portscan','attack','intrusion','relay','other') NOT NULL default 'spam',
  `subject` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `date` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`rid`),
  FULLTEXT KEY `subject` (`subject`),
  FULLTEXT KEY `description` (`description`),
  FULLTEXT KEY `ipaddress` (`ipaddress`)
) TYPE=MyISAM AUTO_INCREMENT=129 ;

<?PHP
$spamquery = mysql_query("SELECT * FROM reports WHERE type = 'spam' ORDER BY ipaddress ASC");
$spamcount = mysql_num_rows($spamquery);
while($spam = mysql_fetch_array($spamquery)){
	$sletjequery = mysql_query("SELECT * FROM sletjes WHERE ipaddress = '$spam[ipaddress]'");
	$sletje = mysql_fetch_array($sletjequery);
	?>
    <td><?PHP echo "<a href='?page=admin/showip&ip=$spam[ipaddress]' title='$sletje[user]'>$spam[ipaddress]</a>"; ?></td>	<?PHP
}
?>

<?PHP
$spamquery = mysql_query("SELECT * FROM reports WHERE type = 'spam' ORDER BY ipaddress ASC");
$spamcount = mysql_num_rows($spamquery);
while($spam = mysql_fetch_array($spamquery)){
	$sletjequery = mysql_query("SELECT * FROM sletjes WHERE ipaddress = '$spam[ipaddress]'");
	$sletje = mysql_fetch_array($sletjequery);
	?>
    <td><?PHP echo "<a href='?page=admin/showip&ip=$spam[ipaddress]' title='$sletje[user]'>$spam[ipaddress]</a>"; ?></td>	<?PHP
}
?>

SELECT ip, COUNT(ip)
FROM where_ever
GROUP BY ip

SELECT ip, COUNT(ip)
FROM where_ever
GROUP BY ip