List Box in PHP/MYSQL

[rettajm]

Hi!

I have a form that inserts data into a mysql table through PHP. On the form, I have a list box. I want to be able to insert multiple values of the list box into MYSQL. Is this possible? If so, how can I do this?

I have tried everying.

[chyan]

yes , you can use loop function to run insert command to store each data in you mysql

[rettajm]

chyan

Can you show me how? I am new to php and mysql and I think I know what you are talking about. Here is my code:

<select name="ProgName[]" multiple style="font-family: arial; font-size: 10pt size="5">
<option value="All">All Travel &amp; Learn Programs</option>
<option value="AmRev">American Revolution Seminar</option>
<option value="CWC">Civil War Conference</option>
<option value="Road">Civil War Studies on the road</option>
<option value="Jeff">Jefferson Symposium</option>
</select>

[chyan]

<?php

echo("<form action='yourinsertscript.php' style='font-family: arial; font-size: 10pt method=get>");

echo "<select name='ProgName[]' multiple style='font-family: arial; font-size: 10pt size='5'>";
echo "<option value='All'>All Travel & Learn Programs</option>";
echo "<option value='AmRev'>American Revolution Seminar</option>";
echo "<option value='CWC'>Civil War Conference</option>";
echo "<option value='Road'>Civil War Studies on the road</option>";
echo "<option value='Jeff'>Jefferson Symposium</option>";
echo "</select>";

printf("<td><input type=submit value=\"submit\"></td>\n");
echo "</form>";
?>

then in yourinsertscript.php

<?php
$count=count($ProgName); // this is for count how much item your users choose
$array=$count-1; // because array start from 0, you must decrease the count by 1

//after that

$i=0; // set the arrray number

for($i=0;$i<=$array;$i++){ // start looping the insert command here

$query="insert into your_table (table_field_here) values ('$ProgName[$i]')";

if(!mysql_query($query,$yourconnection))
{
echo mysql_error();
exit;
}

} // end of looping

?>

i hope this will help you
good luck then

😉