MYSQL ... SELECT... INSERT Statements

[Keith]

Hi
Can any one tell me whether one can INSERT statement to insert data into more than one table.... also in a form SELECT 5 tables to use for 5 dropdown lists and insert this data into a normalization table ?? have not been able to find any references to this anywhere ... how difficult is it to create 5 dropdown lists on one input FORM can you point me in any direction please or better advise ??

[Maelstrom]

I don't think mysql supports multiple table insertion. It is one of those advanced features.

I will ask an advisor to move this to the proper forum where you may get some more detailed answers

[CyberFuture]

I'm pretty sure that you can't INSERT into multiple tables with one query. Just do multiple INSERT queries. If you need to get the ID of the previous insert just use mysql_insert_id().

As for your second question, it works the same for one pull-down menu as it does for 5. Just remeber to keep all the varibles different. I think Chapter 6 of Kevin Yank's book shows an example of this.