URGENT: What is wrong with my counter?>??!??
I have a counter which keeps track of how many times a page has been visited today and how much total. For some reason, my counters keep reseting... im pretty sure my code is good, but maybe its not? Can anyone please see if my code has a problem??
PHP Code:
function CountPage ($pg) {
global $db;
$db->query ("SELECT * FROM counters WHERE page='$pg'");
if ($db->fetchRow ()) {
// Update the count
$curtodaycount = intval($db->record["todaycount"]);
$curtotalcount = intval($db->record["totalcount"]);
// change the date here
$todaydate = $db->record["todaydate"];
$curtotalcount ++;
if ($todaydate == date("Y-m-d")) {
$curtodaycount ++;
}
else {
$todaydate = date("Y-m-d");
$curtodaycount = 0;
// Reset all counters to 0
$db->query("UPDATE counters SET todaydate='$todaydate', todaycount='0'");
}
// Now update the count
$db->query("UPDATE counters SET todaydate='$todaydate', todaycount='$curtodaycount', totalcount='$curtotalcount' WHERE page='$pg'");
}
else {
// Create a new record
$curtodaycount = 1;
$curtotalcount = 1;
$todaydate = date("Y-m-d");
// Insert
$db->query("INSERT INTO counters (page,todaydate,todaycount,totalcount) VALUES('$pg','$todaydate','$curtodaycount','$curtotalcount')");
}
$db->showErrors ();
}
I have no idea whats going on...
