On 6/9/05, Matt Babineau <matt@xxxxxxxxxxxxxxxx> wrote: > 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. Thanks, Matt! > > > 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 > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
