Вот код:
<?php
require('db.php');
$id = $_GET['id'];
if(!isset($_GET['id'])){
header('location: index.php');
}
if(isset($_POST['votar']))
{
if(isset($_POST['valor'])){
$opciones = $_POST['valor'];
$mod = mysql_query("SELECT * FROM survey_var WHERE id = ".$opciones);
//if (!$result) die("mySQL error: ". mysql_error());// errors????
while($result = mysql_fetch_object($mod)){
$valor = $result->valor + 1; // 'valor' + 1 unit
mysql_query("UPDATE survey_var SET valor = '".$valor."' WHERE id = ".$opciones); // SQL
}
header('location: resultado.php?id='.$id); // redirection.
}
}
?>
<!DOCTYPE HTML>
<html lang="en-US">
<head>
<meta charset="UTF-8">
<title>Sistema de encuestas</title>
<link rel="stylesheet" href="estilos.css">
</head>
<body>
<div class="wrap">
<form action="" method="post">
<select id=".$result->id." name="valor">
<?php
$aux = 0;
$sql = "SELECT a.question as question, a.date as date, b.id as id, b.variants as variants, b.valor as valor FROM survey a INNER JOIN survey_var b ON a.id = b.id_survey WHERE a.id = ".$id;
$req = mysql_query($sql);
while($result = mysql_fetch_object($req)){
if($aux == 0){
echo '<h1>'.$result->question.'</h1>';
echo '<ul class="votacion">';
$aux = 1;
}
echo "<option>$result->variants</option>";
}
echo '</ul>';
if(!isset($_POST['valor'])){
echo "<div class='error'>Select an option.</div>";
}
echo "<p><input name='votar' type='submit' value='Votar' class='votar'></p>";
echo "<a href='resultado.php?id=".$id."' class='resultado'>see results</a>";
?>
</select>
</form>
</div>
</body>
</html>