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

Select before to see if exists: if (db_num_rows() > 0) { // Update view where ip = visitor_ip } else { // Normal insert } -- Julio Nobrega. Um dia eu chego lá: http://sourceforge.net/projects/toca Ajudei? Salvei? Que tal um presentinho? http://www.submarino.com.br/wishlistclient.asp?wlid=664176742884 "Philip J. Newman" <newmanpj@philipsdomain.com> wrote in message news:003401c1cf85$1afe54c0$0401a8c0@philip... 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