Vis kun et resultat pr. IP

PHP kode 

 define("DB_SERVER", "*******");
 define("DB_USER", "********");
 define("DB_PASS", "******");
 define("DB_NAME", "*****");
 
 $connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS);
 if (!$connection) {
     die("Database connection failed: " . mysql_error());
 }
 $db_select = mysql_select_db(DB_NAME,$connection);
 if (!$db_select) {
     die("Database selection failed: " . mysql_error());
 }

PHP kode 

 <?php
 
 // database connection.
 include_once("../include/mysql.php");
 
 $browser_type=array(' Explorer', ' Firefox', ' Chrome', ' Safari', ' Netscape', ' Opera', ' Unknown');
 
 // Sender indholdet ind som array.
 $result = array();
 
 // Vælger data fra denne måned på databasen og lægger det sammen.
 $lastmonth = mktime(01, 01, 01, date("m")-1, date("d"), date("Y"));
 $from = date("Y-m-d H:i:s", $lastmonth);
 $to = date("Y-m-d H:i:s");
 $sql = mysql_query("SELECT COUNT(browser) AS antal, browser FROM logger WHERE visitdate BETWEEN '".$from."' AND '".$to."' GROUP BY browser");
 
 
 // Her laver vi en array over resultatet.
 while($row = mysql_fetch_assoc($sql)){
 if(in_array($row["browser"], $browser_type)){
 $result[$row["browser"]] = $row["antal"];
 }else{
 $result["other"] += $row["antal"];
 }}
 
 // her giver vi hver enkel browser et navn.
 $ie = $result[" Explorer"];
 $firefox = $result[" Firefox"];
 $crome = $result[" Chrome"];
 $safari = $result[" Safari"];
 $netscape = $result[" Netscape"];
 $opera = $result[" Opera"];
 $unknown = $result[" Unknown"];
 
 // udregning af det samlet indhold.
 $samlet = ($ie + $firefox + $crome + $safari + $netscape + $opera + $unknown);
 
 $coie = 1; if($ie > 0){} else {$coie = "0";}
 $cofirefox = 1; if($firefox > 0){} else {$cofirefox = "0";}
 $cosafari = 1; if($crome > 0){} else {$cosafari = "0";}
 $cocrome = 1; if($safari > 0){} else {$cocrome = "0";}
 $coopera = 1; if($netscape > 0){} else {$coopera = "0";}
 $conetscape = 1; if($unknown > 0){} else {$conetscape = "0";}
 
 $browserialt = ($coie + $cofirefox + $cosafari + $cocrome + $coopera + $conetscape);
 if($browserialt > 1){
 
 // udregning af hver enkel browsers %.
 $iep = ($ie / ($samlet)) * 100;
 
 $firefoxp = ($firefox / ($samlet)) * 100;
 
 $cromep = ($crome / ($samlet)) * 100;
 
 $safarip = ($safari / ($samlet)) * 100;
 
 $netscapep = ($netscape / ($samlet)) * 100;
 
 $operap = ($opera / ($samlet)) * 100;
 
 $unknownp = ($unknown / ($samlet)) * 100;
 
 include ("browsergraf.php");} 
 else{echo "<br /><h4><span>HOVSA!</span></h4><h3><span>Der er ikke nok data til at<br />vi kan generere en graf over de<br />browsere som har besøgt din<br />webside, kig forbi senere.</span></h3>";}
 
 ?>