Returning the last autoinc value

[Claus Mygind]

I'm trying to get the last auto increment value inserted into a table.

I am using MySQL v.5 with php v5.3. The table engine is MyISAM.

The manual states this is what should be done

SELECT LAST_INSERT_ID();
 

What I get returned is this
"current_field" :null,
"field_count":n ull,
"lengths":n ull,
"num_rows":null ,
"type":null

The insert statement looks like this

insert into myTable set col1=val1, col2=val2
 

I have also tried it with setting the key value to null, with no further luck

Then I created a test table with just two fields key and fill. I tested the code on the MySQL browser like this

insert into t values (null,'xyz');
 
select last_insert_id();
 

and the value displayed on the console was 0 not the last id.

Any suggestions would be appreciated.

[Claus Mygind]

Well I finally got it to work.

Here is the php code

mysql_insert_id();
 

[Dormilich]

The manual states this is what should be done

SELECT LAST_INSERT_ID();

What I get returned is this

"current_field":null,
"field_count":null,
"lengths":null,
"num_rows":null,
"type":null

not really important any more, but the MySQL manual also states that LAST_INSERT_ID( ) returns a BIGINT and not an array/object. so I’d rather assume that the code you used for calling did not expect a single number to be given.