Posted by jack jackson on 07/01/35 11:18

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,

[Back to original message]