Multipule selection into DB

[Jadnet]

This is what i have:

$values .= $id . ",";
$values .= $vars["awards"] . "";

$query = "insert into awarded (userchar, aid) ";
$query .= "values ($values)";

update_db($query);

I have a selection box that has multiple selections I need to have the above code be exicuted for each selection from the selection box, I don't know how to do this. this is a MySQL database.

[Jadnet]

Topic Changed Please help

[shaitan]

The easiest way to do this is to make sure that the list box name in the form has [] after the name (ie selection[]), that way it will be returned to be php as an array.

Then you can use a simple each function to walk through the array and then insert the data into your db.

Shaitan