Can anyone tell me why this isn't working? What its ment to do is add an IP number to the database. if the IP is all ready in the database then it would update a counter.
<?php $proxy_ip=getenv('REMOTE_ADDR'); $proxy_dns=gethostbyaddr($proxy_ip); $add_date=date ("d/F/Y @ h:i:s A"); $sql = "SELECT accessIP FROM `access` ORDER BY `accessID` DESC"; $sql_result = mysql_query($sql, $connection) or die ("Could not get Query"); $row = mysql_fetch_array($sql_result); $accessIP = $row["accessIP"]; if (mysql_num_rows($sql_result) < 0) { // Update view where ip = visitor_ip mysql_query("UPDATE access SET accessVIEW = accessVIEW+1 WHERE accessIP = $accessIP"); } else { // Normal insert $sql = "INSERT INTO `access` (`accessID`, `accessIP`, `accessDNS`, `accessTIME`, `accessUPDATE`, `accessVIEW`) VALUES ('', '$proxy_ip', '$proxy_dns', '$add_date', NOW(NULL), '0')"; $result = mysql_query($sql); } ?> Philip J. Newman PhilipNZ :: Design Solutions http://www.philipnz.com/ [EMAIL PROTECTED] ICQ# 20482482 +64 25 6144012