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;
}