Putting Data into Two Tables 1

[jsnull]

Reference this thread for a similar issue thread434-26323...

What is the current best recommended way to write data into two tables and can you provide an example of the syntax?

table1 has id, name, addresss
table2 has id, orders

table1.id and table2.id are the same.



Jim Null

http://www.jimnull.com

 

[bam720]

I would just do two SQL statements. Im sure it isn't the best way, but tis a solution...

$SQL = 'INSERT INTO `table1`(`id`,`name`,`address`)'; 
$SQL .=	"VALUES ('".$id."','".$name."','".$address."')";
$Result = mysql_query($SQL);

$SQL = 'INSERT INTO `table2`(`id`,`orders`)'; 
$SQL .=	"VALUES ('".$id."','".$orders."')";
$Result = mysql_query($SQL);

 

[sleipnir214]

I would set up the column 'id' in the table 'table1' to be
an auto_increment column. That way, my script could issue the query:

[tt]mysql_query ("INSERT INTO table1 (name, address) VALUES ('a name', 'an address'");[/tt]

and let MySQL automatically generate the value for the 'id' column.

Then I would use the PHP function mysql_insert_id() to fetch the last-automatically-generted value (which would be the value for 'id' from my last insert -- it's designed to work that way). Let's store that value in $last_id:

[tt]$last_id = mysql_insert_id();[/tt]

I would then use that value in a second insert query:

[tt]mysql_query ("INSERT INTO table2 (id, orders) VALUES (" . $last_id . ", 'an order'");[/tt]





Want the best answers? Ask the best questions! TANSTAAFL!

 

[jsnull]

Thank you for your help!

Jim Null

http://www.jimnull.com