[PHP-DB] Storing IP into DB

Hi, I wondered if anyone could help me. I would like to store the user IP only once per multiple visits. The code below store the user IP on every visit which is not my intention. Please I would like to have the IP stored at once upon repetitive visits of the user. Thank Below is my code ?

[PHP-DB] Storing IP into DB

Hi, I wondered if anyone could help me. I would like to store the user IP only once per multiple visits. The code below store the user IP on every visit which is not my intention. Please I would like to have the IP stored at once upon repetitive visits of the user. Thank Below is my code ?

Re: [PHP-DB] Storing IP into DB

I wondered if anyone could help me. I would like to store the user IP only once per multiple visits. The code below store the user IP on every visit which is not my intention. Please I would like to have the IP stored at once upon repetitive visits of the user. Thank Below is my code ?

Re: [PHP-DB] Storing IP into DB

Make your 'ip' column UNIQUE in your table and ignore errors. Or, set a flag in a session or cookie when you save the IP and if that flag is present on other pages, then don't save the IP. Or I believe you can use REPLACE INTO... Chris -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Storing IP into DB

Make your 'ip' column UNIQUE in your table and ignore errors. Or, set a flag in a session or cookie when you save the IP and if that flag is present on other pages, then don't save the IP. Or I believe you can use REPLACE INTO... True. I don't think all databases implement REPLACE,