php form. Send array to database

Avg Bid (USD)
Project Budget (USD)
$30 - $5000

Project Description:
I have a form set up for the person in my running club who organises the volunteers.

The form is called volunteer_event_update.php and asks for:
stri_event and stri_date which is the name of the event and the date on which that event will occur. These can both be entered as text, and there's no problem with these fields.

Next I have 5 fields in which volunteer roles are to be listed. What I would like is the ability to add a number of fields (similar to the way fields can be added to a table on phpMyAdmin (I've set up the textbox and the "Go" button for this, but haven't added the functionality.

Then when the form is submitted, it is processed by the volunteer_event_update_process.php file.

Basically I'd like whatever volunteer roles are put into the volunteer fields, to go into the database in the vol_role field.

So, if a person added an event called "Race 1" on a date "Monday, 1 Jan, 2011", and had 3 volunteer roles: "Pre-race set up", "Course marshall" and "Post-race pack up", I'd like that sent to the database in 3 rows.

Each of the 3 rows would have "Race 1" in the "stri_event" field and "Monday, 1 Jan, 2011" in the "event_date" field. Row 1 would have "Pre race set up" in the vol_role field; row 2 would have "Course marshall" in the vol_role field, and row 3 would have "Post-race pack up" in this field.

There's also a picture of my database if my explanation isn't good enough.



## Deliverables

1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).

## Platform

php and mysql

Skills required:
Anything Goes, Javascript, MySQL, PHP
Additional Files:
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.