mysql_insert_id problems
| From: | Chris Newman | Date: | Fri, 21 Jul 2000 08:52:50 +0000 |
| Subject: | mysql_insert_id problems | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1390@lists.php.net to get a copy of this message | ||
I have a system which shoots off an email with a reference number every time
a record is entered into MySQL. The reference number is formed from the
value of an auto_increment field using mysql_insert_id().
However yesterday a few cracks started appearing - it's sent out emails
containing the same reference number twice, though the database looks sound
(no problems found with isamchk) and it's only inserted one record (the
other one is lost, not just inserted with the next available ID). Are there
any known problems with mysql_insert_id() that might cause this to happen?
Thanks
Chris Newman
Lightwood Consultancy Ltd
chris@lightwood.net