Good day,
I am having a big issue now (that i have my other issues fixed 😛)
with inserting values from drop down menues into my SQL database using PHP.
Right now the way the form works is I create an array of aprox 19 drop down menus all with values that the user should select.
Now the user selects all the values they need to and click the submit button.
When the submit is clicked I need my PHP code to save each value from the Drop Down Box into a database table.
This is the php i used to create the array of select statements
echo <<< EOS
<TD width="10" valign="top"> $cnt </TD>
<TD width="600">$row[questions]</TD>
<TD width="25" valign="top"><SELECT name="ProChoices1">
<OPTION value="N/A" selected>N/A</OPTION>
<OPTION value="0">0 - Never</OPTION>
<OPTION value="25">25 - Seldom</OPTION>
<OPTION value="50">50 - Occasionally</OPTION>
<OPTION value="75">75 - Often</OPTION>
<OPTION value="100">100 - Always</OPTION>
</SELECT>
</TD>
</TR>
EOS;
The way this code works is, it retrieves questions from a MySQL database and prints them to a table. in that HTML table is the question followed by a drop down box with the values as shown. The user will then select the drop box value and click the submit button.
Does anyone know how i then run threw this select drop box in PHP and insert each value?
thanx in advance.
Ulysses Freeman
