> 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
Connect!");
> mysql_select_db("ipvisits")or die("Cant Connect To Database");
> mysql_query("INSERT into visitorsips (ip, date) VALUES ('$ip_address',
'$the_date')");
> 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
