Member Avatar for noel9

how do i stop user inserting duplicate records

INSERT INTO person_tbl(person_name,person_status,creation_time,modified_time) VALUES ('$person',$status,$ctime,$mtime)
WHERE person_name NOT IN(SELECT person_name 
FROM person_tbl
WHERE city_name='$person');
Edited by pritaeas because: Added markdown.
  • 3 Contributors
  • 2 Replies
  • 126 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by rch1231
Member Avatar for pritaeas

Set a unique index on person_name in your table. If you try to insert a duplicate, the query will throw an exception.

Member Avatar for rch1231

Hello,

Pritaeas is correct about the index and you will need to change the insert statement and add IGNORE to cause mysql to ignore the errors when the insert fails due to duplicates.

INSERT IGNORE INTO person_tbl(person_name,person_status,creation_time,modified_time) VALUES ('$person',$status,$ctime,$mtime)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.