[NEWMAN] make an "if" or "else if" statement from mysql.

From: Date: Tue, 19 Mar 2002 20:31:53 +0000
Subject: [NEWMAN] make an "if" or "else if" statement from mysql.
Groups: php.general 
Request: Send a blank email to php-general+get-89199@lists.php.net to get a copy of this message
I have a log of IP numbers that come to WEBSITE A $sql = "INSERT INTO access (accessID, accessIP, accessDNS, accessTIME, accessUPDATE, accessVIEW) VALUES ('', '$proxy_ip', '$proxy_dns', '$add_date', NOW(NULL), '0')"; This has worked well, how ever when someone comes back with the same "accessIP" then I would like then "accessVIEW" aadds a +1 to the value. I would like help to create this .. if (!$remote_addr) <- if the ip that they are using is the same as one in the table then update the record and use the accessID for that record. else if there isn't that $remote_addr in the table then it is added. I have yet to start on the code, so would some direction. Philip J. Newman PhilipNZ :: Design Solutions http://www.philipnz.com/ info@philipnz.com ICQ# 20482482 +64 25 6144012

« previous php.general (#89199) next »