Re: PHP & MySQL get value of auto_increment field of new data
| From: | Matt Schroebel | Date: | Wed, 08 Nov 2000 18:15:57 +0000 |
| Subject: | Re: PHP & MySQL get value of auto_increment field of new data | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-24355@lists.php.net to get a copy of this message | ||
>>> "Tom Harris" <stry_cat@yahoo.com> 11/08 1:06 PM >>>
>I use a PHP script to take data from a web form and insert it into a MySQL
>database. The database has an id field that is AUTO_INCREMENTing and the
>primary key. I want to be able to retrieve the id field that belongs to the
> record I just inserted.
Just use mysql_insert_id()