[Resolved] need help with id

[sinbad]

Hi
i have a php script. The sql portion is:

$sql = "
INSERT into $table_name1

( id , name, products, contact, position, address, city, area, postcode, country, tel, fax, email, website, date)
VALUES
(\"$id\", \"$name\", \"$products\", \"$contact\", \"$position\", \"$address\", \"$city\", \"$area\", \"$postcode\", \"$country\", \"$tel\", \"$fax\", \"$email\", \"$website\", CURDATE())";

$result = @($sql, $connection) or die ("could not execute query.");

$sql = "
INSERT into $table_name2
(customerid, eng, fre, spa)
VALUES
( \"$id\"source\", \"$french\", \"$spanish\")";

$result = @($sql, $connection) or die ("could not execute query.");

The first id in $table_name1
is an auto-increment and is inserted automatically when a new row is added.

In $table_name2 i want to insert the same id as in $table_name1.

Any help please.

Regards

[LordShryku]

Use [man]mysql_insert_id[/man] to find the one you've inserted, then insert it in the second table.

[sinbad]

thanks LordShryku

can you please show me how to use it in the context of my statement.

cheers

[LordShryku]

$result = @mysql_query($sql, $connection) or die ("could not execute query.");
$id     = mysql_insert_id();
$sql    = "INSERT INTO ".$table_name2."
            (customerid, eng, fre, spa)
           VALUES
            ('".$id."', '".$source."', '".$french."', '".$spanish."')";
$result = @mysql_query($sql, $connection) or die ("could not execute query.");

[sinbad]

thanks a lot . my script is fine now.

I just love open source