Update MYQSL with Radio Value

[doddsey_65]

I am trying to update a column in the table with the selected radio value. This is for a rating system i am trying to create but it isnt working. No value is entered into said column.

 

<form name=rate action="<?php echo $_SERVER['PHP_SELF']?>?id=6" method="POST">

<input type=radio name=rate value=1>1
<input type=radio name=rate value=2>2
<input type=radio name=rate value=3 checked>3
<input type=radio name=rate value=4>4
<input type=radio name=rate value=5>5
<input type=submit name=rate value=Rate id=rate><br>
</form>

<?php

$update = $_POST['rate'];

if (isset($_POST['rate'])) {

$rated = mysql_query("UPDATE tutorials SET RatedBy = RatedBy + 1, Rating = Rating + '$update' WHERE id = 6") or die 

(mysql_error());
$res = mysql_query($rated);

 

Anyone know where Im going wrong?