INSERT on two tables.

[Anon]

Hi,

I have two tables:

#TB1
ID_tb1 (auto-incremented)
ID_tb2
name
address

#TB2
ID_tb2 (auto-incremented)
method
status

I need tu run a query that inserts values into #TB1 and #TB2, having #TB1.ID_tb2 equal to #TB2.ID_tb2.

Since #TB2.ID_tb2 is auto incremented, I don't know how to get the same value inserted at #TB1.ID_tb2...

Thanks in advance.

Best Regards,

jO
[e-mail]

[timbolt]

Good question, luckily PHP has a function which helps tremendously:
mysql_insert_id()

After you run your INSERT INTO tb1 sql the autoincrement value is remebered and can be assigned to a variable:

$thevariablename = mysql_insert_id();

This can then be used in your second SQL statement for table 2.

For more (official) details, check:
http://www.php.net/manual/en/function.mysql-insert-id.php

Hope that helps,
Tim Bolt