plznty Posted December 2, 2009 Share Posted December 2, 2009 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()); Quote Link to comment https://forums.phpfreaks.com/topic/183710-duplicate-entry-for-key-1/ Share on other sites More sharing options...
Deoctor Posted December 2, 2009 Share Posted December 2, 2009 change the table structure without using the ip as the primary key Quote Link to comment https://forums.phpfreaks.com/topic/183710-duplicate-entry-for-key-1/#findComment-969616 Share on other sites More sharing options...
plznty Posted December 2, 2009 Author Share Posted December 2, 2009 change the table structure without using the ip as the primary key Just makes it a duplicate entry for key 2 Quote Link to comment https://forums.phpfreaks.com/topic/183710-duplicate-entry-for-key-1/#findComment-969623 Share on other sites More sharing options...
JonnoTheDev Posted December 2, 2009 Share Posted December 2, 2009 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 Quote Link to comment https://forums.phpfreaks.com/topic/183710-duplicate-entry-for-key-1/#findComment-969629 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.