Well after the first query you could do this: $art_id = mysql_insert_id(); There is your new unique art_id you just created. Do this for the next table, the do the insert on your 3rd table. Matt Babineau Criticalcode w: http://www.criticalcode.com p: 858.733.0160 e: matt@xxxxxxxxxxxxxxxx -----Original Message----- From: jack jackson [mailto:jackson.linux@xxxxxxxxx] Sent: Thursday, June 09, 2005 4:06 PM To: php-general@xxxxxxxxxxxxx Subject: Three queries. One Form. Hi, I am trying to make one form on a single page insert info into three tables; query 1 creates an art_id (auto-increment) for the newly created row in table art; query2 creates a media_id in table media. Then I need to get the art_id and media_id created by the first two queries to insert into an intersection table as query three. Must I run an intermediate query to get the ids, and assign it to vars? What would it even look like? Thanks in advance, -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
