Inserting into a database

[ollmorris]

I have some code:

for ($i = 1;$i < count ($REQUEST[option]);$i++) {
while (list(, $choice) = each($REQUEST[option][$i]))
mysql_query ("INSERT INTO options (optionid, choice, status) VALUES ('$optionid','$choice','$_REQUEST[status]')");
}
}

Which should allow me to insert N times into my database (where N is how many $OPTION[] exist). However it doesnt work, the fields which are passed are called OPTION[].

Can anyone help?

[YappyDog]

Instead of just executing the query, why not store it into a variable and then print it out to see what you are getting. That should help to sort out what the problem is.