Description:
------------
Situation:  Inserting records in to a table.  The record ID number is being inserted into the table.  When this is done AND the record has been inserted THEN a call to the insert_id() function in either way (ie: $db->insert_id or mysqli_insert_id($db)) does NOT return the id number just inserted.

This might seem like a dumb thing to do but I stumbled across this because the INSERT command was changed from not sending the record's ID number to setting it.  In either event (setting it or not setting it) - the id number should always be returned when the call is made to the insert_id() function after an INSERT command has been sent.


Test script:
---------------
MySQL:

Set up a simple table (called LOG) in a database with ID, Date, and Entry fields.

PHP:

Use a simple command to insert a record into the above table.

$table = mysqli( "HOST", "USER", "PASSWORD", "DATABASE" );
$sql = "insert into log (id, date, entry) values (1,NOW(),'Test')";
$table->query( $sql );
echo "ID = " . $table->insert_id . "\n";
exit;


Expected result:
----------------
ID = <Record ID>


Actual result:
--------------
ID = 0