How can i check for duplicate records in a form before they are submitted to the database?
I have seen this snippet, but i can't remember where i saw it.
how do you define a "duplicate"? meaning what field(s) have to be repeated to be defined as a duplicate?
are these 2 records duplicates?
name: John Smith city: New York, NY
name: John Smith city: Los Angeles, CA
i was kinda vague.
if a complete row is the same.
devinemke, your example would not be duplicate records.
if both items were the exact same, that would be dup'd.
Originally posted by nmphpwebdev if a complete row is the same.
meaning every value of every field is the same? then simply do a SELECT query to check for an existing record with all same values as the submitted data before your INSERT query.
