ID: 17049
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Feedback
Bug Type: MySQL related
Operating System: FreeBSD
PHP Version: 4.1.2
New Comment:
mysql_insert_id() only returns something if:
-the most recent query was an INSERT query
-AND you're using a AUTO_INCREMENT (and thus PRIMARY KEY) field in the
table you're inserting data to.
If that's not the case, mysql_insert_id() will return 0.
Previous Comments:
[2002-05-06 15:40:13] [EMAIL PROTECTED]
I think you meant mysql_insert_id(), right?
[2002-05-06 15:34:55] [EMAIL PROTECTED]
when mysql_insert_db is used without a parameter, as in
mysql_insert_db(), it seems to always return 0 instead of the primary
key of the most recent insert. It works fine when the db_link is
provided as a parameter. Same problem in PHP 4.0.6 running on Linux.
--
Edit this bug report at http://bugs.php.net/?id=17049edit=1