01-10-2008, 06:46 PM
|
#1 (permalink)
|
|
The Addict
Join Date: Dec 2007
Location: morocco
Posts: 221
Thanks: 19
|
rate error need help
hi
i use this code but everytime the user refresh the page its like if he rate again :s
PHP Code:
<form method="post" action="">
<b>Rate this tutorial</b> <select name="rate">
<option name='ra' selected>Rate</option>
<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 rate set rate='$_POST[rate]',tuto_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>";}
}
if(!isset($_POST['ra'])){
$web="SELECT SUM(`rate`) / COUNT(`rate`) as rate from `rate`";
$tuto=mysql_query($web) or die('Database error: ' . mysql_error());
$mas=mysql_fetch_array($tuto);
echo"The Rating of this tutorial is : <font color=red>".$mas['rate']."</a><br><br>";
}
whats solution
__________________
|
|
|