Duplicate entry ** for key 1

[plznty]

how do i make it so once it has taken the data and stored into the database it doesnt come up as Duplicate entry the next time i visit the page?

 

$IP = $_SERVER['REMOTE_ADDR'];
// MySQL Connection
mysql_connect("localhost", "", "") or die(mysql_error());
mysql_select_db("accesslogs") or die(mysql_error());

mysql_query("INSERT INTO ip 
(ip) VALUES('$IP') ") 
or die(mysql_error()); 

[Deoctor]

change the table structure without using the ip as the primary key

[plznty]

change the table structure without using the ip as the primary key

Just makes it a duplicate entry for key 2

[JonnoTheDev]

Firstly you need to add a primary key to the table i.e id

Make this auto_increment

 

Secondly, if you do not want the same record entered every time a user visits that page you must change the query so that:

1. Select from the table where ip = users ip

2. If record exists do not insert a new record

3. If no record exists insert a new record