Yes this is the page that does the insert to track page views.
I updated line 48 to this:
<?php
if ($rsDetail->getColumnVal("clientid")) {
$InsertQuery = new WA_MySQLi_Query($connBLUR_i);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "profileview";
$InsertQuery->bindColumn("clientid", "i", "".($rsDetail->getColumnVal("clientid")) ."", "WA_DEFAULT");
$InsertQuery->saveInSession("profileview");
$InsertQuery->execute();
$InsertGoTo = "";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>
But now it is adding entries before and after the actual page visited. The attachment shows the actual id inserted for the profile in green. The three entries before and after should not be there. I don't think this is the issue but the field name for the date is "dateview". Is that a reserved word?
thx
Eric