Re: Three queries. One Form.

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