Is it possible to use mysql_insert_id() with a while loop?

Question

 while ($row = mysql_fetch_array($eventchoices)) {

 echo $row['res_name']. " and " .$row['event_name']; 
 echo "<br>";

}

Would like to get the last inserted row to be shown, this currently gets everything in the array, I tried to use mysql_insert_id() like so mysql_insert_id($row); and other methods like using it inside the while loop all attempts come back with errors.

your help is greatly appreciated

Answer 1

mysql_insert_id() only works when inserting records into a table (with an AUTO INCREMENT column). It does not get the ID of the row with SELECT statements. You have to do that in your query.

FYI, mysql_* functions should not be used for new code. They are no longer maintained and the community has begun the deprecation process. See the red box? Instead you should learn about prepared statements and use either PDO or MySQLi. If you can't decide, this article will help to choose. If you care to learn, here is good PDO tutorial.