$result = mysql_query("select linkurl,clicks from combust where link = '1'");while($row = mysql_fetch_assoc($result)) {preg_match("/^(http:\/\/)?([^\/]+)/i", $row[linkurl], $matches);$host = $matches[2];preg_match("/[^\.\/]+\.[^\.\/]+$/", $host, $matches);// $resultz = mysql_query("select linkurl,clicks from combust where linkurl like '%$matches[0]%' order by clicks desc");$resultz = mysql_query("select linkurl,sum(clicks) from combust as totalhits from combust group by linkurl");while($rowz = mysql_fetch_assoc($resultz)) {echo '<tr><td align="left" valign="top">'.$matches[0].'</td><td width="70"><b>Hits: '.$rowz[clicks].'</b></td></tr>';}}