0) { // update if it's alreday in there for today $getPage = mysql_fetch_array($check); $nCount = $getPage['pageCount'] + 1; mysql_query("UPDATE pagehits SET pageCount = '".$nCount."' WHERE pageName = '".$cPage."' AND hDate = '".date('Y-m-d')."'") or die("Can't update"); } else { // insert a new hit record mysql_query("INSERT INTO pagehits (pageName,pageCount,hDate) VALUES ('".$cPage."','1','".date('Y-m-d')."')") or die("Can't update"); } ?>