RE: [PHP] Save ability... Duplicate DB entries
| From: | Mark Charette | Date: | Sat, 10 Aug 2002 17:59:58 +0000 |
| Subject: | RE: [PHP] Save ability... Duplicate DB entries | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-111963@lists.php.net to get a copy of this message | ||
Or, of course, a selection of fields as a unique key. The insert will fail
if there is an exisiting record with that key; you can interrogate the error
and report on the exisitence of a duplicate record.
The select/lock method is used for update purposes ('select for update' et
al.), not to keep duplicate records out of the DB.