dweir

For your pull down option: <select> <option value="name">Option</select> </select> "name" value attribute should match what you are using in your table.

Thanks for the quick reply. Table structure is as follows: valley_id month date hospital ambulance shift The form page has pulldowns for month, date, hospital, ambulance and shift. The page will refresh every 30 seconds so it will update as other students select their clinicals.

I'm at my wits end. I have a mysql db that stores clinical times for a paramedic class. When students select their clinical time and date, I want to check the database to verify that the date and time selected is either available or already taken, and then notify the student if its available or taken. Would this be a mysql query? I'm a greenhorn when it comes to mysql and php. I had this project thrown in my lap a few weeks ago and I'm learning as I go. Any help would be greatly appreciated.

My bad, I should have mentioned that each day on the calendar will have a checkbox for each clinical shift.  Say a student selects the same shift monday through friday for the entire month at the same hospital.  What I'm trying to do is populate the db with a separate entry for each shift that student selected. My reasoning for a separate entry for each shift, each student has a portal page they sign into. When they sign in, their personal page will display their current clinical schedule and a flashing reminder on the day of their clinical, plus other data. Hope this clarifies things.

Hello all, I'm new to the forum and also PHP programming. Here's my dilema, I have a scheduling form that will allow students to select dates and shifts for their clinical rotations.  I have a calendar with each day filled with available clinical shifts.  Currently the form allows for the student to select one clinical date, shift, clinical center and enter their username. The form works well as it will populate the clinical table. What I want to do is allow the student select multiple clinical dates and shifts, and submit the form. The current table structure is username, shift, date and clinical center.  Will php allow me to make multiple entries for a single user to the db without having to alter the table to include more fields for each clinical date and shift chosen? I would prefer a single entry for each clinical date choosen. I've scoured many php sites and can't find anything closely related to what I want to do. Many thanks. Dave