|
|
Posted by Richard Davey on 10/20/42 11:18
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
Navigation:
[Reply to this message]
|