RipCurl
|
| Posted: 04/17/2003, 1:35 PM |
|
Multiple Select box, for new record in 2 tables at the same time
Looking for coding for PHP + Templates in CC 2.0.5 on how to implement a Multiple select box using MYSQL. I can't find any specific thread that addresses or how to show this.
I am making an Events listing and when creating a new "event record", Im working with three tables essentially. The event table will store the "events" description, time, location, etc. So the "created" form by CC will of course only update/insert into that table.
I also need to insert upon creation of the event (or update as well), the information that is being pulled from one table (members) that will be inserted into a third table ( participants ) which will show who is "coming" to the event (with the appropriate event id). And this is where I need coding to create a multi-select box so it pulls the information from the members table to populate the list box, and using CTRL+Click, able to select those who will be participating in the event and insert into the participants table.
So essentially the form has to do three things:
1. Insert new event into event's table. (event_id, name, desc, timebegin, time end, date)
2. Pull information from member's table to populate the multi-select box (member_id, membername)
3. Upon "insert" on the FormAction, also insert into participant table information from both the "new" event (event_id) and the members table (member_id) to show who is going.
None of the examples here show how to do this and the only article in the tips section addresses updates of 2 records at the same time, but not inserting.
|
|
|
|
RipCurl
|
| Posted: 04/21/2003, 12:18 PM |
|
bump
|
|
|
|
RipCurl
|
| Posted: 04/23/2003, 1:13 PM |
|
bump
|
|
|
|
|
|
