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

?>

Comment on this Question and Answer >>>

ASK A QUESTION

More mysql PHP Questions

I am unable to make pages for my search result.Below I am giving the code that I am using. Career Search result Yami says

How do I connect to mySQL from PHP?

My website www.quicheandpie.com has navigation buttons which were added by going to admin/categorylist and adding a category. I can add category = navigation buttons and update them, but I can not delete them. Any ideas how I can find where the info

How do I update the contents of a table row?

I am extracting data from a MySQL Database of which one of the data stored is seperated by a comma. For example, step1,go here,step 2,go there,step 3,go back etc etc. I want to know how to split the data at the comma and format it in html. Using the split