Get ID right after insert...

jbachris

I have the following INSERT command in my code, what I'd like to do is get the ID it is assigned below it.

So:

$add_story_rs = $conn->Execute ( "INSERT INTO story(story_content, story_date) VALUES('" . $_POST['story_content'] . "', NOW())" ) or die ( $conn->ErrorMsg() );

$story_id = $ID; // This is where I'd like to get the ID for the story just added

maxpup979

mysql_insert_id() if the DB is mysql

jbachris

maxpup979 wrote:
mysql_insert_id() if the DB is mysql

It is MySQL. This would work?

$add_story_rs = $conn->Execute ( "INSERT INTO story(story_content, story_date) VALUES('" . $_POST['story_content'] . "', NOW())" ) or die ( $conn->ErrorMsg() );

$story_id = mysql_insert_id();

maxpup979

It will work--assuming that your ID is an autonumber column

from manual:
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.

rulian

You might need the link from your mysql connection, i think earlier versions needed it
if
$CONNECT_LINK=mysql_connect("localhost","user","pass");
mysql_select_db("mydb");

$query=mysql_query("Insert into 'blah' values ('blah')");
if ($query) $id=mysql_insert_id($CONNECT_LINK);

MarkR

Always pass the link into the mysql_ functions. Otherwise, in the future when you add another connection into your scripts, it will all go wrong.

Mark