How to Log Last 5 IP Addresses?

[webosb]

I have a members database which is a table with USERNAME, PASSWORD, LASTIP, DATETIME. Right now, it only logs the last ip that the user has logged in with. How am I able to log the last 5 ip addresses using my current database? Someone please help.

[Kudose]

Well, field LASTIP can only hold one value, so I would assume you wuld need to create 4 more fields to hold the values of the 4 other IPs the user has logged in with.

[Jinks]

there is probably a better way to do this but.....here goes.

When logging the ip do the following.

$current_ip = $REMOTE_ADDR

$result = mysql_query("select * from member_table where username='$username' && lastip='$current_ip'");

if (mysql_num_rows($result) < 1) {
     $result2 = mysql_query("select * from member_table where username='$username' order by datetime");
     if (mysql_num_rows($result2) < 5) 
          mysql_query("insert into member_table (username, password, lastip, datetime) values ('$username','$password','$current_ip',NOW())");
     else {
          $oldest_entry = mysql_fetch_array($result2, MYSQL_BOTH);
          mysql_query("update member_table set lastip='$current_ip', datetime=NOW() where id='$oldest_entry[0]'");
     }
}
else {
     $same_ip = mysql_fetch_array($result, MYSQL_BOTH);
     mysql_query("update member_table set lastip='$current_ip', datetime=NOW() where id='$same_ip[0]'");
}

oh yeah.. and if you dont have a unique ID key for every entry you can either edit your table and ADD one.. or for the first part:

$oldest_entry = mysql_fetch_array($result2, MYSQL_BOTH);
$replace_ip = $oldest_entry["lastip"];
mysql_query("update member_table set lastip='$current_ip', datetime=NOW() where lastip='$replace_ip' && username='$username'");

and for the 2nd part

$same_ip = mysql_fetch_array($result, MYSQL_BOTH);
mysql_query("update member_table set lastip='$current_ip', datetime=NOW() where lastip='$current_ip' && username='$username'");

Hope that helps some.