MySQL Update

nhwaldron

I am trying to update the last record inserted into the database but it appears that other records are actually being updated.

$getrec = "SELECT * from orders WHERE orderid = LAST_INSERT_ID(orders.orderid)";
$result = mysql_query($getrec);
$myrow = mysql_fetch_array($result);

$strUPDATE = "UPDATE orders SET
odprismbase ='$HTTP_POST_VARS[odprismbase]',
osspheresign ='$HTTP_POST_VARS[osspheresign]',
ossphere ='$HTTP_POST_VARS[osphere]',
oscylindersign ='$HTTP_POST_VARS[oscylindersign]',
oscylinder ='$HTTP_POST_VARS[oscylinder]'
WHERE orderid=$myorderid";
$result = mysql_query($strUPDATE, $db)
or print ">>> MySQL-Error: ".mysql_errno()." -> ".mysql_error()."<br>\n";

What am I doing wrong?

Lars_Berg

The last_insert_id() function is only useful after an insert statement. It does not take any argument.

e.g.

$q = "insert into orders values(...)";
$result = mysql_query($q);

$strUPDATE = "UPDATE orders SET 
odprismbase ='$HTTP_POST_VARS[odprismbase]', 
osspheresign ='$HTTP_POST_VARS[osspheresign]', 
ossphere ='$HTTP_POST_VARS[osphere]', 
oscylindersign ='$HTTP_POST_VARS[oscylindersign]', 
oscylinder ='$HTTP_POST_VARS[oscylinder]' 
WHERE orderid= last_insert_id()"; 
$result = mysql_query($strUPDATE, $db)

I don't see what you try to accomplish though. Why should you need to update a newly inserted record?

nhwaldron

The insert statement is huge (53 fields) and from what I could tell there is a limit on the insert statement...so I broke the insert into 1 insert and 5 updates...

nhwaldron

Thanks!

I changed it to: MYSQL_INSERT_ID()
and it appears to be working!