debug version

<?php
setcookie("counter","visitor",time()+3600);

include "conn.php";

$tanggal=date("Y-m-d H:i:s");
echo "<br/>tanggal=$tanggal";
if (!isset($_COOKIE['counter']))
{
    echo "<br/>cookie tidak ada";
$query = mysql_query("select * from counter where tgl='$tanggal'");
while ($rows=mysql_fetch_array($query))
{
    $visit=$rows[1];
}
    echo "<br/>visit = $visit";
}else{
    echo "<br/>cookie ada";
}

if (empty($visit))
{
    mysql_query("insert into counter values('$tanggal',1)");
    echo "<br/>insert 1";
}
else
{   $visit=$visit+1;
    mysql_query("update counter set jml='$visit' where tgl='$tanggal'");
    echo "<br/>update";
}


$hariini=date("Y-m-d");
$query=mysql_query("select distinctrow sum(jml) as tot from counter where year(tgl) = left('$hariini',4) and month(tgl) = mid('$hariini',6,2) and day(tgl) = mid('$hariini',9,2)");
while ($rows=mysql_fetch_array($query))
{
    $jmlhariini=$rows[0];
/*
disini akan di kumpulkan nilai counter hari ini saja.. jadi kl di refresh
maka disini akan bertambah
*/
}

$query=mysql_query("select distinctrow sum(jml) as tot from counter");
while ($rows=mysql_fetch_array($query))
{
    $totvisit=$rows[0];
/*
total keseluruhan counter
*/
}


?>

<html>
<body>
    <table align="left" border="0" width="100%">
    <tr>
    <td>
    <font face="verdana" size="1" color="#000000"><center><?php echo $jmlhariini?> hits today, <?php echo $totvisit?> hits since 21/04/11 </font>
    </td>
    </tr>
    </table>

</body>
</html>