new entry in table - how do I find out it's ID?

[hakalugi]

sorry, but "id" is too short a word for the search function. I saw a post on this last summer, but can't find it using "identifier", etc

basically, if I do:

  
"INSERT INTO responses SET 
	   submitter_dept='$deptname', 
	   ip='$ipaddy',
	   datetime='$stamp' ";

how to I find out the ID assigned to this new entry?

This is to allow for future UPDATEs in the same table for the same record a la:

 
"UPDATE responses SET
	foo='$foo1',
	bar = '$bar1'
	WHERE id='$<the id>";

This is an anonymous survey, so no 'userid' is being entered into this table, but I am using SESSIONs - if you think I should pass and use a SESSION id as a column entry- instead of referencing the row's autoincrement ID--- how do I grab that badboy?

[hakalugi]

&*^$#%@@ I hit preview, it gave me an error, now I see it posted and I did another double.

oh well...

sorry, but "id" is too short a word for the search function. I saw a post on this last summer, but can't find it using "identifier", etc [img]images/smilies/frown.gif[/img]

basically, if I do:

 
"INSERT INTO responses SET 
submitter_dept='$deptname', 
ip='$ipaddy',
datetime='$stamp' ";

how to I find out the ID assigned to this new entry?

This is to allow for future UPDATEs in the same table for the same record a la:

 
"UPDATE responses SET
foo='$foo1',
bar = '$bar1'
WHERE id='$<the id>";

This is an anonymous survey, so no 'userid' is being entered into this table, but I am using SESSIONs - if you think I should pass and use a SESSION id as a column entry- instead of referencing the row's autoincrement ID--- how do I grab that badboy?

[sojomy]

mysql_insert_id() will return the ID of the last inserted row.
after the insert, use this

<?
$LastInsertedID = mysql_insert_id();
$SQLStatement = 'UPDATE responses SET foo=\'' . $foo1 . '\', '
              . 'bar=\'' . $bar1 . '\' WHERE id=' . $LastInsertedID
mysql_query($SQLStatement);
?>

[Helge]

I think you need to run the mysql_insert_id() function after you've updated the database. Not before.

-Helge

[DR_LaRRY_PEpPeR]

yeah, but he meant that code should go after the INSERT has been done, to be used in the UPDATE.

[Helge]

Sorry.
I should start reading the posts more carefully...

-Helge

[Dr Livingston]

It shouldn't matter is it's INSERT or UPDATE so long as the field is auto_increment (on mySQL anyways).