Totaal aantal bezoekers

<?php
//****************************//
//BEZOEKERS, VANDAAG EN TOTAAL//
//****************************//
$mysql = mysql_connect("localhost", "*****", "*****");
$database = mysql_select_db("*****", $mysql);

# Variabelen aanmaken
$sIpAddress     =   $_SERVER['REMOTE_ADDR'];
$sDate          =   date("dmy");

# Verwijderen van oude records
$rDelete = mysql_query("DELETE FROM `counter` WHERE date != '".$sDate."'");

# Kijken of iemand vandaag al niet een keer eerder is geweest
$rCheckVisit = mysql_query("SELECT COUNT(counterid) FROM `counter` WHERE `date` = '".$sDate."' AND `ip` = '".$sIpAddress."'");

# Wanneer iemand vandaag niet eerder is geweest
if (mysql_result($rCheckVisit, 0) == 0) {
    
    $rInsert = mysql_query("INSERT INTO `counter` (date, ip) VALUES ('".$sDate."', '".$sIpAddress."')");

}

# Ophalen van de counter gegevens
$rGetLast = mysql_query("SELECT `counterid` FROM `counter` ORDER BY `counterid` DESC LIMIT 1");
$aLast = mysql_fetch_row($rGetLast);

$rGetToday = mysql_query("SELECT COUNT(counterid) FROM `counter` WHERE `date` = '".$sDate."'");

# Aanmaken van de variabelen
$counter['today']   = mysql_result($rGetToday, 0);
$counter['total']   = $aLast['counterid'];

//****************************//
//       ALLES WEERGEVEN      //
//****************************//

echo '<table border="0">';
 	
echo '<tr><td>Bezoekers vandaag:</td><td><b>'.$counter['today'].'</b></td></tr>';
echo '<tr><td>Bezoekers totaal:</td><td><b>'.$counter['total'].'</b></td></tr>';

echo '</table>';

<?php
//****************************//
//BEZOEKERS, VANDAAG EN TOTAAL//
//****************************//
$mysql = mysql_connect("localhost", "*****", "*****");
$database = mysql_select_db("*****", $mysql);
 
# Variabelen aanmaken
$sIpAddress     =   $_SERVER['REMOTE_ADDR'];
$sDate          =   date("dmy");
 
# Verwijderen van oude records
$rDelete = mysql_query("DELETE FROM `counter` WHERE date != '".$sDate."'");
 
# Kijken of iemand vandaag al niet een keer eerder is geweest
$rCheckVisit = mysql_query("SELECT COUNT(counterid) FROM `counter` WHERE `date` = '".$sDate."' AND `ip` = '".$sIpAddress."'");
 
# Wanneer iemand vandaag niet eerder is geweest
if (mysql_result($rCheckVisit, 0) == 0) {
 
    $rInsert = mysql_query("INSERT INTO `counter` (date, ip) VALUES ('".$sDate."', '".$sIpAddress."')");
 
}
 
# Ophalen van de counter gegevens
$rGetLast = mysql_query("SELECT `counterid` FROM `counter` ORDER BY `counterid` DESC LIMIT 1");
$aLast = mysql_fetch_row($rGetLast);
 
$rGetToday = mysql_query("SELECT COUNT(counterid) FROM `counter` WHERE `date` = '".$sDate."'");
 
# Aanmaken van de variabelen
$counter['today']   = mysql_result($rGetToday, 0);
$counter['total']   = $aLast['counterid'];
 
//****************************//
//       ALLES WEERGEVEN      //
//****************************//
 
echo '<table border="0">';
 
echo '<tr><td>Bezoekers vandaag:</td><td><b>'.$counter['today'].'</b></td></tr>';
echo '<tr><td>Bezoekers totaal:</td><td><b>'.$counter['total'].'</b></td></tr>';
 
echo '</table>';