I've used this before:
$query = "INSERT INTO myusers SET lname='$lname', fname='$fname'"; mysql_query($query) or die('Query failed: ' . mysql_error()); //GET ID FOR LAST INSERT $id = mysql_insert_id();
to get a row id so I can use it after an insert, but is there anything similar for easily getting a row id after an update like this?
$queryg = "UPDATE study SET answers='$answerarray' WHERE userid='$userid'"; $resultg = mysql_query($queryg) or die('Query failed: ' . mysql_error());
I need the row # from this Updated record to alter a different table in my database, and wondered if there is an easy way to get it, or do I have to just get it by doing yet another query?
Thanks in advance!