> I was wondering what is the best way to insert multiple records into a > table? Here is the scenario... > > I have a form which has 5 select menus as part of the data that gets > entered. Most of the data goes into a table called tbl_reports. Each of > these 5 menus contains the same list of people (from tbl_people). I > have another table which I am calling tbl_report_people which I want to > INSERT a record for each person that is selected for any new report (I > hope this is making sense). So for example, a new report form is filled > out and submitted. 3 of the people selects are used, so I need to add > to the tbl_report_people table the record_id and person_id for each > person selected. The fastest way will be to create your INSERT dynamically and do them all at once. The format would be: INSERT INTO table (column1, column2) VALUES (value1,value2),(value11,value22),(value111,value222) If you're getting record_id and person_id from a form, you can just loop through them and create each (value,value) part and then add on the beginning. Without seeing your actual form, that'd be about the best advice I can give. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
