Using LAST_INSERT_ID( )

[Vic Spainhower]

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

[Gordon Burditt]

>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).
The return value of mysql_query is *NOT* the value for last_insert_id( ).
Fetch a row (e.g. using mysql_fetch_row ) and then look at the column
you want, and *thats* the value you are looking for.
.............. ............... .
$_SESSION["entryID"] = (mysql_query ('SELECT LAST_INSERT_ID( ) FROM
tblShowEntries '));

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

Gordon L. Burditt

[Vic Spainhower]

Thanks Gordon,

The following code seems to work fine ....

$query = "SELECT LAST_INSERT_ID( )";
$result = mysql_query($qu ery);
if ($result) {
$nrows = mysql_num_rows( $result);
$row = mysql_fetch_row ($result);
$lastID = $row[0];
$_SESSION["entryID"] = $lastID;
}
Vic
"Gordon Burditt" <go***********@ burditt.org> wrote in message
news:11******** *****@corp.supe rnews.com...

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).

The return value of mysql_query is *NOT* the value for last_insert_id( ).
Fetch a row (e.g. using mysql_fetch_row ) and then look at the column
you want, and *thats* the value you are looking for.

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

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

Gordon L. Burditt

[Kim André Akerø]

Vic Spainhower wrote:

Thanks Gordon,

The following code seems to work fine ....

$query = "SELECT LAST_INSERT_ID( )";
$result = mysql_query($qu ery);
if ($result) {
$nrows = mysql_num_rows( $result);
$row = mysql_fetch_row ($result);
$lastID = $row[0];
$_SESSION["entryID"] = $lastID;
}

Please note that the PHP function mysql_insert_id () will return the
same as you're trying to fetch.

$lastID = mysql_insert_id ();

http://php.net/mysql_insert_id

--
Kim André Akerø
- ki******@NOSPAM betadome.com
(remove NOSPAM to contact me directly)