Parse and/or script error

Anon

Hi,
What errors do you see in the following. I'm getting a parse error at the while statement.
And in general, I am having problems getting the data posted to the mysql database:

PLEASE INDICATE THE FOLLOWING:
Profession:
<input type="checkbox" name="visitor_profession[0]">Lighting Showroom
<input type="checkbox" name="visitor_profession[1]">Designer
<input type="checkbox" name="visitor_profession[2]">Architect
<input type="checkbox" name="visitor_profession[3]">Electrical Supply Wholesaler
<input type="checkbox" name="visitor_profession[4]">Purchasing Agent
<input type="checkbox" name="visitor_profession[5]">Sales Representative
<input type="checkbox" name="visitor_profession[6]">Other

<?php
reset($visitor_profession);
while( each($id, $value) = list($visitor_profession) )
{
if($value == "on")
{
db_query("INSERT visitor_profession ".
"(user_ID, profession_id) ".
"VALUES ($user_ID, $id)");

}
}

?>
Please Specify if Your Profession is not Listed
PROFESSION:<input type="text" name="visitor_profession_specified" size="48">
REQUESTS CAN
NOT BE PROCESSED WITHOUT TOTALLY COMPLETED FORM

                <p><input type="submit" name="submit" value="Submit" value="Reset">
          </table>

</FORM>
<?php
}
?>

zalath

Are you trying to save the data before the form gets posted? seems to me you are. Try putting the php code in a different file and specifying that file as the form action.

-L-

Anon

It should be the other way:

list($id, $value) = each($visitor_profession)

Diego