[thelist] undefined index error - PHP and MySQL

Pringle, Ron RPringle at aurora-il.org
Mon May 7 14:32:06 CDT 2007

Using PHP 5.1 and MySQL 5.12, I am inserting a record into my database and then attempting to grab the auto-incremented id. The insert works fine but trying to define the last_insert_id as a var is blowing up on me. My code is:

mysql_query("select last_insert_id() as histID from tbl_history");
$result = mysql_query($query, $coacalendar);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$historyID = $row['histID'];  <---- LINE 60
echo "<p>History ID is: $historyID</p>\n";

The errors are:

Notice: Undefined index: histID in inc_edit_confirm.php on line 60

Out of range value adjusted for column 'histID' at row 1

When I run the query manually it aliases the column correctly, but returns a value of 0 instead of the proper value.

I've googled around off and on today but I'm not seeing the probably obvious issues here.

Any help would be greatly appreciated.


More information about the thelist mailing list