I have been trying to just simply add whatever the user picks from the radio form to the field "number" in their specified user table. I cannot get it working. Any ideas on what is wrong? It does not add the choice into the specified field, it leaves it null
<?php
if(isset($_POST['submit']))
{
$number=$_POST['number'];
if($number!="")
{
$query=mysql_query("UPDATE users SET number = '$number' WHERE name = '".$user->name."';");
if($query)
{
header('Location: /me');
}
else
{
$error_message = '<font color="red"><strong>Please choose a number.</strong></font><br /><br />';
}
}
}
?>
<form method="post" action="post">
<input type="radio" name="number" value="1" />1
<input type="radio" name="number" value="2" />2
<input type="radio" name="number" value="3" />3
<input type="submit" name="submit" />
</form>