Is there any easy way to do this...

[Channel5]

Let's say I insert a row into my database and I want to get the id for that row immediately after, is there a quicker way to do that than how I've been doing it so far:

mysql_query("INSERT INTO database
(var1, var2)
VALUES('$var1', '$var2')")
or die;

$result = mysql_query("SELECT id FROM database
ORDER BY id DESC")
or die;

$row = mysql_fetch_array($result);
$id = $row[id];

[onicsoft]

yep, after you do a mysql insert then you can get the id of the insert by doing mysql_insert_id(); and then get the what the next one will be by adding 1 to that number.

[bradgrafelman]

onicsoft wrote:

and then get the what the next one will be by adding 1 to that number.

And due to the race condition, remember that adding one might not get you the ID of the next row inserted in the same script.

In fact, you should switch to using the function mentioned above since your code is vulnerable to the popular 'race condition' as well.

[Channel5]

Let's see if I'm reading this right...

Not this:

mysql_query("INSERT INTO database
(var) VALUES('$var')")
or die;

echo mysql_insert_id();

But this:

mysql_query("INSERT INTO database
(var) VALUES('$var')")
or die;

echo mysql_insert_id()+1;

[bradgrafelman]

The +1 that onicsoft mentioned was only to predict what the next inserted row would be (which, as I mentioned, might not work some times and shouldn't be considered reliable).

If you want the ID of the row you just inserted, there's no need to add anything.