Posted by NC on 09/11/06 15:01

Pugi! wrote:
>
> In a mysql database you have a table, with an integer
> as primary key. You've specified auto_increment.
> Using PEAR to access your database how do you
> get hold of the value of the primary key of a row you
> just inserted ?

Call mysql_insert_id():

http://www.php.net/mysql_insert_id

Cheers,
NC

• Next in forum: Re: mysql select help
• Prev in forum: Re: mysql dump creates empty file
• Thread view: Re: How to get the value of an auto_increment primary key after an insert ?

[Reply to this message]