the reate code douesnt work SOS plz

webtuto · 01-10-2008, 02:42 PM

why this code douesnt work !!!!!!!!

PHP Code:


			
<form method="post" action="">
<b>Rate this tutorial</b> <select value="rate">
<option name=1>1</option>
<option name=2>2</option>
<option name=3>3</option>
<option name=4>4</option>
<option name=5>5</option>
<input type="submit" value="rate" name="value">
</form>
<?php
if($_POST['value']){
$sql="insert into `tutorialz`.`tuto` SET `rate`='$_POST[rate]' WHERE `id`='$get'";
$res = mysql_query($sql) or die('Database error: ' . mysql_error());
if($res) {
  echo"Thanks for rating<br><br>";
}else{echo"it was a problem in the rate plz try again!<br><br>";}
}

I use it to rate the tutorialz in my script

and it gives error =>
Database error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `id`='5'' at line 1