How do I find the ID of a new row added to a table?

If you are adding data to a mySQL table then you will often want to know the ID of a row you have just inserted so that you can reference it elsewhere. Often you'll add to a table with an auto_increment ID field and then want to use this to store other information on other tables.

Here's how you do it:


<?php

$q = mysql_query("INSERT INTO mytable VALUES('test')");

$rownumber = mysql_insert_id();

//$rownumber contains the id of the new row

?>

Categories

PHP Functions

More PHP

How do I find the ID of a new row added to a table?

More mysql PHP Questions