If you have multiple check-boxes, all named the same, followed by [], each representing an ID of a vote you want updated, you can accept them in PHP as an array.
You can use that array to build a list of ID's that need to be updated, and pass that into an IN() clause in your SQL.
For example:
-
<?php
-
if(isset($_POST['submitted'])) {
-
# Connect to the database
-
# ... You know the drill
-
-
# Get the votes and *implode* them into a list
-
$votes = $_POST['vote'];
-
$voteList = implode(", ", $votes);
-
-
# Create a query, using the list in a IN() clause
-
$SQL = "UPDATE tally SET tvote = tvote + 1 WHERE nid IN ({$voteList})";
-
echo "<pre>", $SQL, "</pre>";
-
}
-
?>
-
-
<form action="?" method="post">
-
<input type="checkbox" name="vote[]" value="1" /> Vote 1 </br>
-
<input type="checkbox" name="vote[]" value="2" /> Vote 2 </br>
-
<input type="checkbox" name="vote[]" value="3" /> Vote 3 </br>
-
<input type="checkbox" name="vote[]" value="4" /> Vote 4 </br>
-
<input type="submit" name="submitted" />
-
</form>
-
