MYSQL Primary Key

[ccole]

I have my MYSQL table's primary key set so that it auto increments (meaning it goes up on it's own). If I insert a new row, does anyone know how to find out what it's automatically generated primary key is going to be?

That was a confusing question...it's all right if nobody understands.

[suresk]

Here's one way to do it in PHP:

First grab the last ID from the row you inserted:

PHP Code:

$lid = mysql_fetch_row(mysql_query("SELECT LAST_INSERT_ID()")); 


then add one to it:

PHP Code:

$newid = $lid+1; 


Does that help?

[suresk]

err.. Maybe I mis-understood you

If you mean what the number assigned to it will be, ignore the second part, the $lid = .... part gives you the Key assigned to it.

[ccole]

EXACTLY what I wanted, thanks a lot spencer!