updating multiple checkbox entries into php mysql database

[TechnoAtif]

Hi All..'mAtif..i've got stuck within checkboxes these days..i've got many input items like checkboxes,textarea and along with them there are many checkboxes...all the data except the checkbox's is comfortably getting entered into the database but the real problem is with the checkboxes..only one entry is being stored ...but i want to enter the multiple entries from the checkboxes to enter into the database...the form is a voting poll..and i have made use of arrays..but i'm not able to get the right way of how to enter the multiple checkbox entries into mysql..plz help..the code follows...It has two tables...the updata checkbox data is to be entered into the 'tally' table... .More than one votes can be dne through checkboxes and as they are checked,there entry should be made into the table..plz help.as quick as possible..thanx in advance...the code follows:

<Code removed>

[Markus]

Strange...

=\
this has happened on both of your threads..

[TechnoAtif]

ya.it is atrange...plz help ..how culd i find its soluiton

[rizwan6feb]

This could help u.Check this

[Atli]

Hi.

I have removed the 519 lines of code you posted.
Such a large amount of code can not be handled correctly, making you post appear empty.
Try posting an "example" of your code, perhaps the areas you feel will be most useful to us.

And besides that, 519 lines of code will scare most readers away ^^

[Atli]

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>