I have been trying to learn mySQL for the past few months before I embark on this adventure,and searching for as many answers as I could. I administer a website for a Non-Profit Bluegrass organization,and for the past few years send back and forth an "Excel" file with Gate submissions.

I would like to construct a Form so the Gate Supervisor would be able to administer the sign up himself. My question is,is it possible to have a drop down list to select a given shift to insert into the selected shift table.

I have used your code I found to populate the dropdown box with all the shifts.My mysql_fetch_array works with what I have already added into with phpadmin and a simple form I made.

the Shift table consists of..the id(auto increment,shift,name1,name2,name3,name4.

So in essence,a form with 4 text boxes for name1,name2,name3,name4...the drop down menu for selecting the given shift will be the only things other than submit on the form..

I just don't know how to get the drop down box when selected to..INSERT INTO..

I have 6 months to work on this and am willing to learn from whatever I'm taught. I am already kinda familiar with the sql_fetch..insert.. phpadmin..etc.

I figured I'd ask here..you people seem to know everything..

...Thank You...
...Rodney...

[edited by: Ocean10000 at 6:51 pm (utc) on Oct 12, 2014]
[edit reason] URL Removed [/edit]