I have a problem duplicate entry in same time. I am getting some parameters in other gateway (some websites) and stored in Database. I trim all parameters. Before i store in db, i check db whether that record already exist or not.
Other Gateway website which they send three time to us. First time i capturing all the parameters and check it db and stored, if not already exist.
But sometime stored duplicate entry in same hours,minutes and seconds also. This cause, i can not check db also.
Same record stored in two or three row in table.
Still i have a headache how solve this problem. Please give me any idea to solve this issues.
I am using php and mysql.
Sample record as in table Mysql
you can see the date. time, min and seconds everything is same :(
e_id, name, amount, date.
e_id - > this is unique and auto increment.
e_id name amount Date
125 test 150 2011-03-19 09:46:38
126 test 150 2011-03-19 09:46:38
127 test 150 2011-03-19 09:46:38