php poll produces endless loop of results

wikedawsum

Would someone mind taking a look at this code and tell me why, when I submit a vote on my poll system, the results come back in an endless loop? I'm following a tutorial online and trying to modify it to fit my needs. This is the only portion that's messing me up (so far). I've poured over the code for hours and cannot seem to figure out what's going on. Any help is appreciated.

<?php

$conn = mysql_connect("mysql.*****.com", "*****", "****") 
or die($msg_no_connect);
mysql_select_db("*****") 
or die(mysql_error());

$query = "SELECT * FROM pollQuestions";
$res = mysql_query($query);

if(mysql_num_rows($res) > 0){
	while ($row = mysql_fetch_assoc($res)){
		echo '<table cellpadding="5" cellspacing="0" border="0">
			  <tr>
					<td><p>'; echo $row["question"]; echo '</p></td>
			  </tr>
			  <tr>
				<td style="padding-left:10">
				<form name="submit_vote" action="test_poll.php?pollid='.$row["id"].'" method="post">
				<input type="hidden" name="pollid" id="pollid" value="'.$row["id"].'">';
				for($i = 1; $i <= 10; $i++)
					{
						if($row["answer" . $i ] != "")
						{
							echo '<input type="radio" name="answer" value="'.$row["answer$i"].'">';
							echo $row["answer" . $i];
							echo '<br>';
						}
					}
				echo "<br>";
				if (isset($_SESSION['auth_user'])){
					echo '<input type="submit" name="submit_vote" id="submit_vote" value="Vote Now">';
				} else {
					echo 'You must be logged in to vote.';
					}
				echo '</form>
				</td>
			</tr>
			</table>';
		}

		if (isset($_POST['submit_vote'])){

		$id = (int)$_GET['id'];
		$answer = $_POST['answer'];
		$pollid = $_POST['pollid'];
		$username = $_SESSION['auth_user'];

		$addvote = mysql_query("INSERT INTO pollAnswers (pollid, answer, username) VALUES ('$pollid', '$answer', '$username')");

		$showvotes = "SELECT * FROM pollQuestions pq INNER JOIN pollAnswers pa ON pq.id = pa.pollid WHERE pq.id = '$id'";
		$res = mysql_query($showvotes);

	$answertally[0] = 0;
	$answertally[1] = 0;
	$answertally[2] = 0;
	$answertally[3] = 0;
	$answertally[4] = 0;
	$answertally[5] = 0;
	$answertally[6] = 0;
	$answertally[7] = 0;
	$answertally[8] = 0;
	$answertally[9] = 0;

	$answertotal = 0;

	while($row = mysql_fetch_assoc($res))
		{
			switch($row["answer"])
				{
					case $row["answer1"]:
					$answertally[0]++;
				break;
					case $row["answer2"]:
					$answertally[1]++;
				break;
					case $row["answer3"]:
					$answertally[2]++;
				break;
					case $row["answer4"]:
					$answertally[3]++;
				break;
					case $row["answer5"]:
					$answertally[4]++;
				break;
					case $row["answer6"]:
					$answertally[5]++;
				break;
					case $row["answer7"]:
					$answertally[6]++;
				break;
					case $row["answer8"]:
					$answertally[7]++;
				break;
					case $row["answer9"]:
					$answertally[8]++;
				break;
					case $row["answer10"]:
					$answertally[9]++;
				break;
				}

			// Get the total number of votes
			for($i = 0; $i < sizeof($answertally); $i++)
			$answertotal += $answertally[$i];

			mysql_data_seek($res, 0);

			for($i = 1; $i <= 10; $i++)
				{
					if($row["answer$i"] != "")
						{?>
							<table>
								<tr>
									<td bgcolor="#FFEFCE" style="padding-left:10" width="50%" colspan="1" height="21">
									<?php echo $row["answer$i"] . " [" . number_format(($answertally[$i-1] / $answertotal) * 100, 0, ".", '') . "%]" . "<br>"; ?>
									</td>

									<td bgcolor="#FFEFCE" style="padding-left:10" width="45%" colspan="1" height="21">
									<img src="images/line.gif" width="<?php echo ($answertally[$i-1] / $answertotal) * 100; ?>" height="5">
									</td>

									<td bgcolor="#FFEFCE" style="padding-left:10" width="5%" colspan="1" height="21"></td>
								</tr>
							</table>
						<?php
						}
				}
		}
	}
}
?>

Thanks very much in advance!

wikedawsum

bradgrafelman

Towards the end of your script, you use [man]mysql_data_seek/man to return MySQL's internal pointer back to the first row, which is endlessly retrieved in the while() loop.

wikedawsum

Hello, bradgrafelman. Thanks for your response. I removed the mysql_data_seek from the script and it stopped the endless looping. However, my results are now displayed like the attachment shows.

I have 4 question responses setup in my database.. so it's basically repeating the 4 responses 6 different times.

I've split up my poll script to display on the results for now. Below is new script coding.

<?php 

$conn = mysql_connect("mysql.******.com", "******", "*****") 
or die($msg_no_connect);
mysql_select_db("*******") 
or die(mysql_error());

$showvotes = "SELECT * FROM pollQuestions pq, pollAnswers pa WHERE pq.id = pa.pollid AND pq.id = '1'";
$res = mysql_query($showvotes);

	$answertally[0] = 0;
	$answertally[1] = 0;
	$answertally[2] = 0;
	$answertally[3] = 0;
	$answertally[4] = 0;
	$answertally[5] = 0;
	$answertally[6] = 0;
	$answertally[7] = 0;
	$answertally[8] = 0;
	$answertally[9] = 0;

	$answertotal = 0;

	while($row = mysql_fetch_array($res))
		{
			switch($row["answer"])
				{
					case $row["answer1"]:
					$answertally[0]++;
				break;
					case $row["answer2"]:
					$answertally[1]++;
				break;
					case $row["answer3"]:
					$answertally[2]++;
				break;
					case $row["answer4"]:
					$answertally[3]++;
				break;
					case $row["answer5"]:
					$answertally[4]++;
				break;
					case $row["answer6"]:
					$answertally[5]++;
				break;
					case $row["answer7"]:
					$answertally[6]++;
				break;
					case $row["answer8"]:
					$answertally[7]++;
				break;
					case $row["answer9"]:
					$answertally[8]++;
				break;
					case $row["answer10"]:
					$answertally[9]++;
				break;
				}

			// Get the total number of votes
			for($i = 0; $i < sizeof($answertally); $i++)
			$answertotal += $answertally[$i];;

			for($i = 1; $i <= 10; $i++)
				{
					if($row["answer$i"] != "")
						{?>

								<tr>
									<td bgcolor="#FFEFCE" style="padding-left:10" width="50%" colspan="1" height="21">
									<?php echo $row["answer$i"] . " [" . number_format(($answertally[$i-1] / $answertotal) * 100, 0, ".", '') . "%]" . "<br>"; ?>
									</td>

									<td bgcolor="#FFEFCE" style="padding-left:10" width="45%" colspan="1" height="21">
									<img src="images/line.gif" width="<?php echo ($answertally[$i-1] / $answertotal) * 100; ?>" height="5">
									</td>

									<td bgcolor="#FFEFCE" style="padding-left:10" width="5%" colspan="1" height="21"></td>
								</tr>

						<?php
						}
				}
		}?>
</table>

What am I missing? Thanks again for any responses.