Afstemning virker ikke ordenligt Hjælp
Jeg kan ikke få min afstemning til at virke...Den vil ikke indsætte i mysql dben,når man vælger et svar mulighed.Den viser bare mulighederne igen,uanset hvad for en mulighed man vælger..Mvh:
Jens
Først mysl db :
--
-- Struktur-dump for tabellen `afstem`
--
CREATE TABLE `afstem` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`svar1` varchar(255) NOT NULL default '',
`svar2` varchar(255) NOT NULL default '',
`svar3` varchar(255) NOT NULL default '',
`svar4` varchar(255) NOT NULL default '',
`svar5` varchar(255) NOT NULL default '',
`svar6` varchar(255) NOT NULL default '',
`svar7` varchar(255) NOT NULL default '',
`svar8` varchar(255) NOT NULL default '',
`svar9` varchar(255) NOT NULL default '',
`svar10` varchar(255) NOT NULL default '',
`status` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Data dump for tabellen `afstem`
--
INSERT INTO `afstem` VALUES (2, '''Hvad synes du om siden?', 'God', 'Der mangler noget', 'Dårlig', '', '', '', '', '', '', '', 'Open');
-- --------------------------------------------------------
--
-- Struktur-dump for tabellen `afstem_svar`
--
CREATE TABLE `afstem_svar` (
`id` int(11) NOT NULL auto_increment,
`spmid` int(11) NOT NULL default '0',
`brugernavn` varchar(18) NOT NULL default '',
`ip` varchar(255) NOT NULL default '',
`tid` tinytext NOT NULL,
`spm` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;
Her er min kode:
<?
if($user && $adgang) {
include("connect.php");
$query = mysql_query("SELECT * FROM afstem WHERE id = '2' ORDER BY id DESC") or die(mysql_error());
$r = mysql_fetch_array($query);
$result = mysql_query("SELECT * FROM afstem_svar WHERE brugernavn = '".$user."'");
if(isset($post) && mysql_num_rows($result) == "0"){
$ip = $_SERVER[REMOTE_ADDR];
$tid = date("d/m-y H:i:s");
$test = mysql_query("INSERT INTO afstem_svar (spmid, brugernavn, spm, tid, ip)" . "VALUES ('2','$user','$post','$tid','$ip')") or die(mysql_error());
}
$result = mysql_query("SELECT * FROM afstem_svar WHERE brugernavn = '".$user."'");
if(mysql_num_rows($result) == "0"){
?>
<form action="forside.php" name="afstem" method="POST">
<table border="0" cellpadding="0" cellspacing="0" class="afstem">
<tr>
<td colspan="2"><? echo"$r[title]";?></td>
</tr>
<?
if ($r["svar1"] != ""){
?>
<tr>
<td>
<input type="radio" value="1" cheked name="1">
</td>
<td>
<?=$r["svar1"]?>
</td>
<?
}
if ($r["svar2"] != ""){
?>
<tr>
<td>
<input type="radio" value="2" name="1">
</td>
<td>
<?=$r["svar2"]?>
</td>
<?
}
if ($r["svar3"] != ""){
?>
<tr>
<td>
<input type="radio" value="3" name="1">
</td>
<td>
<?=$r["svar3"]?>
</td>
<?
}
if ($r["svar4"] != ""){
?>
<tr>
<td>
<input type="radio" value="4" name="1">
</td>
<td>
<?=$r["svar4"]?>
</td>
<?
}
if ($r["svar5"] != ""){
?>
<tr>
<td>
<input type="radio" value="5" name="1">
</td>
<td>
<?=$r["svar5"]?>
</td>
<?
}
if ($r["svar6"] != ""){
?>
<tr>
<td>
<input type="radio" value="6" name="1">
</td>
<td>
<?=$r["svar6"]?>
</td>
<?
}
if ($r["svar7"] != ""){
?>
<tr>
<td>
<input type="radio" value="7" name="1">
</td>
<td>
<?=$r["svar7"]?>
</td>
<?
}
if ($r["svar8"] != ""){
?>
<tr>
<td>
<input type="radio" value="8" name="1">
</td>
<td>
<?=$r["svar8"]?>
</td>
<?
}
if ($r["svar9"] != ""){
?>
<tr>
<td>
<input type="radio" value="9" name="1">
</td>
<td>
<?=$r["svar9"]?>
</td>
<?
}
if ($r["svar10"] != ""){
?>
<tr>
<td>
<input type="radio" value="10" name="1">
</td>
<td>
<?=$r["svar10"]?>
</td>
<?
}
?>
<tr>
<td></td>
<td><input type="submit" value="Stem"></td>
</tr>
</table>
</form>
<?
}else{
?>
<table border="1" cellpadding="0" bordercolor="#666666" cellspacing="0" style="border-collapse: collapse" width="100%">
<tr>
<td colspan="1"></td>
</tr>
<?
$result = mysql_query("SELECT * FROM afstem_svar WHERE spmid = '2'");
$antal_stem = mysql_num_rows($result);
$tal = "1";
while($tal <= 10){
$tal1 = $tal++;
if ($r["$tal1"] != ""){
$spm = "$tal1";
$q = mysql_query("SELECT * FROM afstem_svar WHERE spmid = '2' AND spm = '$spm'");
$spm1 = mysql_num_rows($q);
$spmsvar = $spm1 / $antal_stem * 100;
?>
<tr>
<td width="100%"><?=$r["$tal1"]?></td>
</tr>
<tr>
<td width="100%"><table bgcolor="#d00000" border="1" bordercolor="#666666" cellspacing="0" cellpadding="0" height="10" width="<? echo "$spmsvar"; ?>%"><tr><td></td></tr></table><? echo "$spmsvar"; ?>%</td>
</tr>
<?
}
?>
<? } }?>
</table>
<? } else { ?>
<font color="red"><b>Du er ikke logget ind!<br><br></b>
Du skal være logget ind for at stemme!</font>
<?
}
?>
