Using LAST_INSERT

From: Vic Spainhower <vic@showsec.com>
Date: Sat Oct 01 2005 - 18:45:59 CEST

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";
Received on Tue Oct 18 02:30:15 2005

comp.lang.php archive

Using LAST_INSERT_ID()