I've got a select statement that lists differnt types of food and from which users can make multiple selections, what I then need the form to do is pass all the selections into a table field, but at the moment all it will do is pass the last one.

So for example if you select "curry, noodles, laksa and roaches" off a select list, all that is passed to the table is roaches.

Here is the code snippet:

<p>Food type:</p></td><td><p><select name="food" size="5" multiple>

$result = mysql_query("SELECT * FROM category",$db);
if ($myrow = mysql_fetch_array($result)) {
do {
printf("\t<option value=\"%s\">%s\n",$myrow["id"],$myrow["title"]);
} while ($myrow = mysql_fetch_array($result));
} else{
echo "no records";

the table "catgory" holds the types of food.

Any suggestions would be much appreciated.