Inserts into Multiple Tables

[klycette]

I'm using Dreamweaver's Insert Record behaviour for PHP to insert information into 2 mySQL tables. I've been able to insert into one table fine, but I'm wondering what's the best way to insert into both at the same time. My problem is that one of the pieces of data that I want to insert into the second table is the automatically generated id from the previous insert. How do I get this id that was just created and place it in the second insert. I'm pretty new, so please try to keep it simple. Thanks.

[amitrb]

use

$id=mysql_insert_id()

to get the id

[dartcol]

This will do it for you.
$result=mysql_query("INSERT INTO table1 (col2) VALUES('".addslashes($_POST['$variable'])."')") or die(mysql_error());
$result=mysql_query("INSERT INTO table2 (col2) VALUES(LAST_INSERT_ID())") or die(mysql_error());

Here's a link to the manual for more reading 🙂
http://www.mysql.com/doc/en/Getting_unique_ID.html

You should really do a search for this though as it's a pretty common question. There's a reply to this on this page. 😃