Re: [PHP] more about Last_insert_id

2001-01-24 Thread Richard Lynch
$sql1 = "insert into firsttable (firstname, lastname) values('Jack','Chan')"; $resultsql1 = mysql_query($sql1); Add ... or die(mysql_error()) to the end of that line. $sqlLastID = "select LAST_INSERT_ID() from firsttable"; $resultlast = mysql_query($sqlLastID); Add the same thing here. $FirstL

[PHP] more about Last_insert_id

2001-01-24 Thread [EMAIL PROTECTED]
I got here the syntax that is suppose to get the id from the "just inserted" record and store it in value, did not work so far and I cannot see what is wrong in there, can anyone give me a hint what is wrong here? ( And the reason I did not use mysql_insert_id here is because the ID field at my