Thanks for this Richard! On 6/9/05, Richard Davey <rich@xxxxxxxxxxxxxxxx> wrote: > Hello jack, > > Friday, June 10, 2005, 12:05:35 AM, you wrote: > > jj> I am trying to make one form on a single page insert info into three > jj> tables; query 1 creates an art_id (auto-increment) for the newly > jj> created row in table art; > > jj> query2 creates a media_id in table media. > > jj> Then I need to get the art_id and media_id created by the first two > jj> queries to insert into an intersection table as query three. > > Assuming MySQL - just use 2 insert statements and after each one get > the last_insert_id. Once you've got both of those you can perform your > third and final insert using both of those values. > > Best regards, > > Richard Davey > -- > http://www.launchcode.co.uk - PHP Development Services > "I do not fear computers. I fear the lack of them." - Isaac Asimov > > -- > 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
