[SOLVED] capture Autonumber id

[otuatail]

Is there a wat to capture Autonumber id of an inserted record. I need to add a record to table A and place the unique Autonumber id in table B

 

TIA

 

Desmond.

 

[Aureole]

Yes there is, I believe this is how you do it but this is only off the top of my head.

 

<?php
$query= "...";
$result = mysql_query($query);
$insert_id = mysql_insert_id($result);
// Now you can use $insert_id for your second query...

$query2 = "INSERT INTO `...` (id, something, somethingelse) VALUES ('{$insert_id}', 'value', 'another value')";
$result2 = mysql_query($query2);
// ...
?>

[otuatail]

Great thanks for that worked fine TIA

 

Desmond.