Question: take multiple selected from dropdown and ...

datona

What I need to know is advise and/or help with the following:

1: Registration Form that has a dropdown box
2: Client chooses multiple from dropdown box.
3: Once submitted, this information is stored in a MySQL database.
4: Retrieve and display that information later.

Dropdown would have somthing like:
Things I like to do are:
-> Basketball
-> Tennis
-> Soccer
-> Volleyball

If the person chooses Basketball, Soccer, and Volleyball, then when it is displayed later, it would display like:

The sports that I like to do are:
Basketball, Soccer, and Volleyball

Note the commas and the AND

What I am looking for is the best way to retrieve these choices (Is it easier and/or better to be checkboxes?), storing them in the database some how, and then retreiveing them and displaying in the format shown above.
Any help for this newbie would be greatly appreciated.
Thanks

sijis

html for select multiple.

<select name="item_sport[]" size="5" multiple id="item_sport[]">
<option value="sport 1">Sport 1</option>
<option value="sport 2">Sport 2</option>
<option value="sport 3">Sport 3</option>
</select>

php. adding to mysql.

$item_sport = implode(",", $_POST['item_sport']);
$strSQL = "INSERT INTO Table (Sport) Values ('$item_sport')";
mysql_query($strSQL);

retrieving value from mysql
// get the values from you db and put it in a $variable
// ex: $i_sport = $row['sport_field'];

since it should be in an array, just foreach() to spit it out.
i haven't tested this, but it should work.

foreach($i_sport as $sport){
$format_sport = "$sport, ";
}

// pretty output
echo rtrim($format_sport,", ");

hopefully this gives you a starting point.
and i'm sure there are other method of doing this.

datona

WOW sijis!!

If only I could shake your hand. Thank you very much for helping me out on this matter.

From what I have read, you have laid out the whole structure.

Thanks again