how to get a value of an autoincrement id after insert in mysql

[heldopsokken]

Hello,

Is there any way to find out the value of the id (wich is autoincrement)
when using the following statements:

$query = "INSERT into rfc values
('','$gebruiker','$omschrijving','$reden','$aanspr eekpunt')";
$sql = mysql_query($query) or trigger_error(mysql_error(), E_USER_WARNING);

[Garp]

"heldopsokken" <fietsbelbellen@$#@NO******@hotmail.com> wrote in message
news:40*********************@news.xs4all.nl...

Hello,

Is there any way to find out the value of the id (wich is autoincrement)
when using the following statements:

$query = "INSERT into rfc values
('','$gebruiker','$omschrijving','$reden','$aanspr eekpunt')";
$sql = mysql_query($query) or trigger_error(mysql_error(),

E_USER_WARNING);

For MySQL at least, there's http://www.php.net/mysql_insert_id
as in :
$id=mysql_insert_id();

Garp

[Chris Hope]

heldopsokken wrote:

Is there any way to find out the value of the id (wich is autoincrement)
when using the following statements:

$query = "INSERT into rfc values
('','$gebruiker','$omschrijving','$reden','$aanspr eekpunt')";
$sql = mysql_query($query) or trigger_error(mysql_error(),
E_USER_WARNING);

Use the mysql_insert_id() function which can be found in the MySQL section
of the manual at http://www.php.net/mysql_insert_id

In a MySQL query string you can also use "SELECT LAST_INSERT_ID()"

Both of these return the id generated from the most recent insert query.

--
Chris Hope
The Electric Toolbox - http://www.electrictoolbox.com/

[heldopsokken]

Thanks a lot!

"Garp" <ga***@no7.blueyonder.co.uk> wrote in message
news:Ae******************@news-text.cableinet.net...

"heldopsokken" <fietsbelbellen@$#@NO******@hotmail.com> wrote in message
news:40*********************@news.xs4all.nl...

Hello,

Is there any way to find out the value of the id (wich is autoincrement)
when using the following statements:

$query = "INSERT into rfc values
('','$gebruiker','$omschrijving','$reden','$aanspr eekpunt')";
$sql = mysql_query($query) or trigger_error(mysql_error(),

E_USER_WARNING);

For MySQL at least, there's http://www.php.net/mysql_insert_id
as in :
$id=mysql_insert_id();

Garp