mysql_insert_id() returning 0 ?

[baffled_in_UK]

Hello,
I was trying out this function and all I get back is zero.

My test table is defined as :
id mediumnint (7) unsigned autoincrement
field1 varchar 50
field2 char 1

$sql = "INSERT INTO table(field1,field2) VALUES ('$field1','$field2')";   

$id = mysql_insert_id();

The record is written and the id value is fine in the MySQL Db table

Am I missing something ?

Thanks

[tomhath]

Try echoing the value of $last_id on the line after the call to mysql_insert_id. My guess is that it was set correctly, but something happened to that variable afterward (went out of scope, misspelled, etc).

[baffled_in_UK]

This is driving me nuts. I did as tomhath suggested and it is ZERO immediately after the successful insert into the table.

Somebody please help or suggest some other way (not max(id) please).

Cheers

[xblue]

if this is your code, I doubt it can work at all. you are assigning some text (the sql statement) to a variable, but you don't execute it before calling mysql_insert_id. (I guess your are doing mysql_query sometimes later, else I wouldn't know how your insert statement could be successful 😉)

it should look something like this:

$sql = "INSERT INTO table(field1,field2) VALUES ('$field1','$field2')";   

mysql_query($sql);
$id = mysql_insert_id();