id autoincrement

[Scrumpers]

I have an id auto increment field which I send a 0 to when writing to the database but I would like to write this value to another table id which is not auto increment.

Is there a command to capture this value before I write to the second table ?

[Lars_Berg]

You don't mention which DBMS but presumably it is Mysql. Use the function

mysql_insert_id

after the insert on the first table

[Scrumpers]

$Link = mysql_connect ($Host, $User, $Password);
$Query = "INSERT into $TableName values (NULL, '$Array[FirstName]', '$Array[LastName]', '$Array[Company]', '$Array[Address]', '$Array[Address1]', '$Array[Address2]', '$Array[Address3]', '$Array[Postcode]', '$Array[Tel]', '$Array[Email]', '$Array[ArrivDate]', '$Array[NumNight]', '$Array[OneBed]', '$Array[TwoBed]', '$Array[Family]', '$Array[Confirm]')";

$Captureid = mysql_insert_id();
print ("$Captureid");

This gives me 0 everytime can anyone tell me where I am going wrong ?

[Lars_Berg]

As you never execute the insert statement ...

[Scrumpers]

I put it just before the database close and it works a dream ta very much