Still Trying
Good afternoon Ray:
I have attempted to figure this out on my own with little success. I have, however, discovered a pattern to my problem:
If I vote for person A, person B (the next person in the voting list) gets that vote and all of the total votes of person A. Even if the person is not 'visible' from my database, they still hog the votes of the previous person.
Here is the SQL code:
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE candidates SET numberVotes=%s+1 WHERE id=%s",
GetSQLValueString($_POST['voteValue'], "int"),
GetSQLValueString($_POST['voteValue'], "int"));
Here is the Form PHP/HTML:
<form action="<?php echo $editFormAction; ?>" method="POST" name="form1" id="form1">
<?php do { ?>
<input type="radio" value="<?php echo $row_rsCandidates['numberVotes']; ?>" name="voteValue" id="<?php echo $row_rsCandidates['id']; ?>" /><?php echo $row_rsCandidates['candidate']; ?><br />
<?php } while ($row_rsCandidates = mysql_fetch_assoc($rsCandidates)); ?>
Question:
Would the data and security assist products help create more specific queries (server behaviors)? I have yet to purchase but am strongly considering if they would aid in the server behavior area.
Thank you for the support Ray!