prevent the value change

[gohhs]

hello, if i insert a record into table divefile:

mysql_query( "INSERT INTO divefile(`dive_diverid`, `dive_filename`, `dive_orifilename`) VALUES('$Divername', '$filetype2','$filetype2')" );
$new_id = mysql_insert_id(); 

and i assign the $new_id to mysql_insert_id.
the system return the $new_id as 33 if this is the no 33 record.

if later on the same code i insert another record into another table, the $new_id become 0, how should i prevent the value store inside $new_id change?

many thanks.

[byron3@earthlink]

hello, if i insert a record into table divefile:

$new_id = mysql_insert_id(); 

and i assign the $new_id to mysql_insert_id.
the system return the $new_id as 33 if this is the no 33 record.

if later on the same code i insert another record into another table, the $new_id become 0, how should i prevent the value store inside $new_id change?

Read the documentation @ :
http://us2.php.net/mysql_insert_id

The return value is the ID generated for an AUTO_INCREMENT column by the previous INSERT query on success, 0 if the previous query does not generate an AUTO_INCREMENT value, or FALSE if no MySQL connection was established.