> 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
> <?
> $ip_address = getenv ("REMOTE_ADDR");
> $the_date = date("Y-m-D");
> $connect = mysql_connect("localhost", "user", "pass") or die("Cant
> mysql_select_db("ipvisits")or die("Cant Connect To Database");
> mysql_query("INSERT into visitorsips (ip, date) VALUES ('$ip_address',
> mysql_close($connect);

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.

---John Holmes...

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to