this code doesnt work and i cant seem to see where it goes wrong.
<?php
$db = @mysql_connect("localhost", "***", "*");
mysql_select_db("*****", $db);
$ip=getenv(REMOTE_ADDR);
$result = mysql_query("SELECT FROM rates where REMOTE_ADDR='$ip' AND rid=$id;",$db);
$number = mysql_numrows($result);
?>
<? printf("%s\n", $number);?>
if ($number != 0) {
<p>Here you rate the users for skill, loox and attitude</p>
<p>Submit only once, go BACK and RELOAD to see your addition.</p>
<form method="post" action="<?php ratelistadds.php3+$id?>">
<div align="left">
<p>Skill Rating:
<select name=ratings>
<option value="">- Select -</option>
<option value="20">blaa<option>
<option value="40">Novice</option>
<option value="60">Average</option>
<option value="80">Inhuman</option>
<option value="100">Godlike</option>
</select>
</p>
<br>
<?php $rid = $id; ?><input type="hidden" name="rid" value="<?php echo $rid ?>"
<br>
</p>
<p>
<input type="Submit" name="submit" value="Enter information">
</p>
</div>
</form>
} else if ($submit) {
<?PHP
// process form
$db = @mysql_connect("localhost", "", "****");
mysql_select_db("****",$db);
$date = date("Y-m-d");
$sql1 = "INSERT INTO rates (ratings,rid,REMOTE_ADDR,date) VALUES ('$ratings','$rid','$REMOTE_ADDR','$date')";
$result1 = mysql_query($sql1);
?>
} else {
<?PHP
echo "YOUR HAVE VOTED.\n";
}
?>
</td>
</tr>
</table>
