View Single Post
Old 01-10-2008, 02:42 PM   #1 (permalink)
webtuto
The Addict
 
webtuto's Avatar
 
Join Date: Dec 2007
Location: morocco
Posts: 221
Thanks: 19
webtuto is on a distinguished road
Default the reate code douesnt work SOS plz

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
__________________
Send a message via MSN to webtuto Send a message via Yahoo to webtuto Send a message via Skype™ to webtuto
webtuto is offline  
Reply With Quote