Page 1 of 1

Database Listing...

Posted: Tue Mar 28, 2006 4:30 pm
by maxfavela
Is there a way to set fixed numbers, for id's of
every listing inputed into my database?

Also, is there a protocol or program, or code
I can use to automatically remove duplicates?



Appreciate your time.

Posted: Tue Mar 28, 2006 4:37 pm
by feyd
  1. That's what an AUTO_INCREMENT tagged field is for.
  2. I'd start by setting certain fields to UNIQUE, or possibly looking in the database to see if a the record you'd like to insert already exists that way duplicates don't happen "normally"