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";

• Next in forum: Re: Using LAST_INSERT_ID()
• Prev in forum: Re: [Announce] PHPLint 0.3 - PHP source parser and validator
• Thread view: Using LAST_INSERT_ID()

[Reply to this message]