Re: Retrieving newly created ID from MySQL?
| From: | Leif K-Brooks | Date: | Thu, 27 Mar 2003 04:21:30 +0000 |
| Subject: | Re: Retrieving newly created ID from MySQL? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-141165@lists.php.net to get a copy of this message | ||
The manual is your friend! :) Have a look at http://www.php.net/manual/en/function.mysql-insert-id.php.
Ben Cheng wrote:
If I have a MySQL table with an auto-incrementing ID field, is there an easy way to retrieve the new ID after I insert a new row into the table? For example, if I insert a row into a table with ID, Title, & Content fields, is there a way I can get the ID value without doing a separate select where the Title & Content fields are equal to the values I just inserted? -Ben-- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.