How do i find out the ID that was givin to the INSERT query (auto_increment id)

Pests

I need to insert data into mysql, and know what ID was givin to it. The id feild is auto_increment. Is there any way to do this?

BlooPanthr

You have to reconnect to get the info.

$sql = "SELECT id FROM table";
$result = @mysql_query($sql,$connection) or die(mysql_error());

while ($row = mysql_fetch_array($result))
{
          $id = $row['id'];
}

That should work, as long as you replace table with the table name and id with whatever you named the field for your auto-incrementing field.

Lars_Berg

$q = "select last_insert_id()"
$result = mysql_query($q);
$row = mysql_fetch_array($result);
$newID = $row[0];

Using a loop is slow and prone to error.

hand

http://www.php3.de/manual/en/function.mysql-insert-id.php

mysql_query("INSERT INTO mytable (product) values ('kossu')");
print "Last inserted id:".mysql_insert_id()."<br>\n";

Pests

Thanks hand. Just what i was looking for, i knew i should have checked the php site before i posted..but i wouldnt have a clue what it would be named.