Getting incremental ID number back after doing an INSERT?

[vozzek]

Hi all,

Simple question, may be a simple answer (dunno) but here goes:

Let's say my table's key element is "id" and it's self-incrementing. After I do an INSERT into the table... is there a way to know what the id number that was generated was? Because I want to do another INSERT into another table based upon that id number.

Does mySQL return this value anywhere? Or is finding this id number more of a php thing? Thanks in advance.

[vozzek]

Okay, I actually found the answer to my own question - so I'm posting it below:

<?
$tablename = "tablename";
$next_increment = 0;
$qShowStatus = "SHOW TABLE STATUS LIKE '$tablename'";
$qShowStatusResult = mysql_query($qShowStatus) or die ( "Query failed: " . mysql_error() . "<br/>" . $qShowStatus );
 
$row = mysql_fetch_assoc($qShowStatusResult);
$next_increment = $row['Auto_increment'];
 
echo "next increment number: [$next_increment]";
?>

Thanks to all who read this anyway. :)