Duplicate record enter in DB Table

hello

I am facing one problem in my project.

Data entered by user here UserId is unique auto increment by code


UserId Name Time

12LAB00019 Vijay 24Nov 2012 02:11:34PM
12LAB00019 Vijay 24Nov 2012 02:11:34PM

one user get same UserId in database table it store as
UID - This is auto increment

UID UserId Name Time

18 12LAB00019 Vijay 24Nov 2012 02:11:34PM
19 12LAB00019 Vijay 24Nov 2012 02:11:34PM
Double Record entered in Database


This is another big problem that one user entered so many time
from 5234 to 5248 all ids are taken by this user

UserId Name Time

12LAB05234 Jay Kumar 30Nov 2012 5:00:25PM
12LAB05234 Jay Kumar 30Nov 2012 5:00:25PM

12LAB05237 Jay Kumar 30Nov 2012 5:00:26PM
12LAB05237 Jay Kumar 30Nov 2012 5:00:26PM
12LAB05237 Jay Kumar 30Nov 2012 5:00:26PM

12LAB05239 Jay Kumar 30Nov 2012 5:00:27PM
12LAB05239 Jay Kumar 30Nov 2012 5:00:27PM

12LAB05242 Jay Kumar 30Nov 2012 5:00:28PM
12LAB05242 Jay Kumar 30Nov 2012 5:00:28PM
12LAB05242 Jay Kumar 30Nov 2012 5:00:28PM

12LAB05244 Jay Kumar 30Nov 2012 5:00:29PM
12LAB05244 Jay Kumar 30Nov 2012 5:00:29PM

12LAB05246 Jay Kumar 30Nov 2012 5:00:32PM
12LAB05246 Jay Kumar 30Nov 2012 5:00:32PM

12LAB05248 Jay Kumar 30Nov 2012 5:00:33PM
12LAB05248 Jay Kumar 30Nov 2012 5:00:33PM

In Admin section this data is coming in such a way

Please suggest what should i do

We need to see your PHP code

Sponsor our Newsletter | Privacy Policy | Terms of Service