INSERT Question

From: Date: Sat, 29 Mar 2003 22:16:53 +0000
Subject: INSERT Question
Groups: php.db 
Request: Send a blank email to php-db+get-26702@lists.php.net to get a copy of this message
Hi there. 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. How is this done? Thanks Charles

« previous php.db (#26702) next »