Keeping the results of a poll in a mysql table..
Posted: Fri May 02, 2003 2:55 pm
What im trying to code is a poll, that keeps the number of votes for each option in a mysql table.. ive coded something, and what its supposed to do is take only the first line of the table(limit 1, DESC). in the table i have 6 fields.. 5 answers and one pollid(auto inc) so i can have something to sort it by. What its supposed to do is if the person voted for answer1, then whatever is in answer1 in the mysql table and add 1 to it, put it back in the table, also taking answer2-5 and submitting those to the table to, so that i dont lose their values when someone votes for something. Heres the code ive got so far:
This code is not working- when someone votes for answer 1, it reads the results back to the person like so:
Answer1:1
Answer2:
Answer3:
Answer4:
Answer5:
even if answer1 had already had a vote in it.
This is the code that im using to read the results back to the person:
Any help is greatly appreciated, thanks in advance!
Code: Select all
if($answer1 == V1){
$query = "SELECT answer1 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$result = mysql_query($query);
$answerup = mysql_fetch_row($result);
$answerup = $answerup[0];
$answerup = $answerup++;
$queryfortwo = "SELECT answer2 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultfortwo = mysql_query($queryfortwo);
$answerfortwo = mysql_fetch_row($resultfortwo);
$answerfortwo = $answerfortwo[0];
$queryforthree = "SELECT answer3 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforthree = mysql_query($queryforthree);
$answerforthree = mysql_fetch_row($resultforthree);
$answerforthree = $answerfortwo[0];
$queryforfour = "SELECT answer4 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforfour = mysql_query($queryforfour);
$answerforfour = mysql_fetch_row($resultforfour);
$answerforfour = $answerforfour[0];
$queryforfive = "SELECT answer5 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforfive = mysql_query($queryforfive);
$answerforfive = mysql_fetch_row($resultforfive);
$answerforfive = $answerforfive[0];
$query2 = "INSERT INTO smecs_poll_results (answer1, answer2, answer3, answer4, answer5) VALUES('$answerup', '$answerfortwo', '$answerforthree', '$answerforfour', '$answerforfive')";
mysql_query($query2);
}
if($answer1 == V2){
$query = "SELECT answer1 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$result = mysql_query($query);
$answerup = mysql_fetch_row($result);
$answerup = $answerup[0];
$queryfortwo = "SELECT answer2 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultfortwo = mysql_query($queryfortwo);
$answerfortwo = mysql_fetch_row($resultfortwo);
$answerfortwo = $answerfortwo[0];
$answerfortwo = $answerfortwo++;
$queryforthree = "SELECT answer3 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforthree = mysql_query($queryforthree);
$answerforthree = mysql_fetch_row($resultforthree);
$answerforthree = $answerfortwo[0];
$queryforfour = "SELECT answer4 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforfour = mysql_query($queryforfour);
$answerforfour = mysql_fetch_row($resultforfour);
$answerforfour = $answerforfour[0];
$queryforfive = "SELECT answer5 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforfive = mysql_query($queryforfive);
$answerforfive = mysql_fetch_row($resultforfive);
$answerforfive = $answerforfive[0];
$query2 = "INSERT INTO smecs_poll_results (answer1, answer2, answer3, answer4, answer5) VALUES('$answerup', '$answerfortwo', '$answerforthree', '$answerforfour', '$answerforfive')";
mysql_query($query2);
}
if($answer1 == V3){
$query = "SELECT answer1 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$result = mysql_query($query);
$answerup = mysql_fetch_row($result);
$answerup = $answerup[0];
$queryfortwo = "SELECT answer2 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultfortwo = mysql_query($queryfortwo);
$answerfortwo = mysql_fetch_row($resultfortwo);
$answerfortwo = $answerfortwo[0];
$queryforthree = "SELECT answer3 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforthree = mysql_query($queryforthree);
$answerforthree = mysql_fetch_row($resultforthree);
$answerforthree = $answerforthree[0];
$answerforthree = $answerforthree++;
$queryforfour = "SELECT answer4 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforfour = mysql_query($queryforfour);
$answerforfour = mysql_fetch_row($resultforfour);
$answerforfour = $answerforfour[0];
$queryforfive = "SELECT answer5 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforfive = mysql_query($queryforfive);
$answerforfive = mysql_fetch_row($resultforfive);
$answerforfive = $answerforfive[0];
$query2 = "INSERT INTO smecs_poll_results (answer1, answer2, answer3, answer4, answer5) VALUES('$answerup', '$answerfortwo', '$answerforthree', '$answerforfour', '$answerforfive')";
mysql_query($query2);
}
if($answer1 == V4){
$query = "SELECT answer1 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$result = mysql_query($query);
$answerup = mysql_fetch_row($result);
$answerup = $answerup[0];
$queryfortwo = "SELECT answer2 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultfortwo = mysql_query($queryfortwo);
$answerfortwo = mysql_fetch_row($resultfortwo);
$answerfortwo = $answerfortwo[0];
$queryforthree = "SELECT answer3 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforthree = mysql_query($queryforthree);
$answerforthree = mysql_fetch_row($resultforthree);
$answerforthree = $answerfortwo[0];
$queryforfour = "SELECT answer4 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforfour = mysql_query($queryforfour);
$answerforfour = mysql_fetch_row($resultforfour);
$answerforfour = $answerforfour[0];
$answerforfour = $answerforfour++;
$queryforfive = "SELECT answer5 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforfive = mysql_query($queryforfive);
$answerforfive = mysql_fetch_row($resultforfive);
$answerforfive = $answerforfive[0];
$query2 = "INSERT INTO smecs_poll_results (answer1, answer2, answer3, answer4, answer5) VALUES('$answerup', '$answerfortwo', '$answerforthree', '$answerforfour', '$answerforfive')";
mysql_query($query2);
}
if($answer1 == V5){
$query = "SELECT answer1 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$result = mysql_query($query);
$answerup = mysql_fetch_row($result);
$answerup = $answerup[0];
$queryfortwo = "SELECT answer2 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultfortwo = mysql_query($queryfortwo);
$answerfortwo = mysql_fetch_row($resultfortwo);
$answerfortwo = $answerfortwo[0];
$queryforthree = "SELECT answer3 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforthree = mysql_query($queryforthree);
$answerforthree = mysql_fetch_row($resultforthree);
$answerforthree = $answerfortwo[0];
$queryforfour = "SELECT answer4 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforfour = mysql_query($queryforfour);
$answerforfour = mysql_fetch_row($resultforfour);
$answerforfour = $answerforfour[0];
$queryforfive = "SELECT answer5 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultforfive = mysql_query($queryforfive);
$answerforfive = mysql_fetch_row($resultforfive);
$answerforfive = $answerforfive[0];
$answerforfive = $answerforfive++;
$query2 = "INSERT INTO smecs_poll_results (answer1, answer2, answer3, answer4, answer5) VALUES('$answerup', '$answerfortwo', '$answerforthree', '$answerforfour', '$answerforfive')";
mysql_query($query2);
}
?>Answer1:1
Answer2:
Answer3:
Answer4:
Answer5:
even if answer1 had already had a vote in it.
This is the code that im using to read the results back to the person:
Code: Select all
$query = "SELECT answer1 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultanswer1 = mysql_query($query);
$resultsone = mysql_fetch_row($resultanswer1);
$resultsone = $resultsone[0];
$query = "SELECT answer2 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultanswer2 = mysql_query($query);
$resultstwo = mysql_fetch_row($resultanswer2);
$resultstwo = $resultstwo[0];
$query = "SELECT answer3 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultanswer3 = mysql_query($query);
$resultsthree = mysql_fetch_row($resultanswer3);
$resultsthree = $resultsthree[0];
$query = "SELECT answer4 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultanswer4 = mysql_query($query);
$resultsfour = mysql_fetch_row($resultanswer4);
$resultsfour = $resultsfour[0];
$query = "SELECT answer5 FROM smecs_poll_results ORDER BY pollid DESC limit 0,1";
$resultanswer5 = mysql_query($query);
$resultsfive = mysql_fetch_row($resultanswer5);
$resultsfive = $resultsfive[0];
$result3 = "SELECT * FROM smecs_poll ORDER BY pollid DESC limit 0,1";
$result2 = mysql_query($result3);
{
while($rowanswers=mysql_fetch_array($result2)) {
print "<b><center>".$rowanswers["answer1"]."</b>:".$resultsone;
print "<b><center>".$rowanswers["answer2"]."</b>:".$resultstwo;
print "<b><center>".$rowanswers["answer3"]."</b>:".$resultsthree;
print "<b><center>".$rowanswers["answer4"]."</b>:".$resultsfour;
print "<b><center>".$rowanswers["answer5"]."</b>:".$resultsfive;
}