Posted by Vic Spainhower on 10/01/05 19:45

Hello,

I am trying to get the value of the Auto-Incremented key that was assigned
using LAST_INSERT_ID(). However, when I execute the following PHP statements
after the insert I only get: "value of entryID: Resource id #7" after EVERY
insert (it never changes).

What am I doing wrong?

Thanks very much!

Vic
...............................
$_SESSION["entryID"] = (mysql_query ('SELECT LAST_INSERT_ID() FROM
tblShowEntries'));

$entryID = $_SESSION["entryID"];
echo "value of entryID: $entryID";

[Back to original message]