[RESOLVED] Mysql Help!!!!!!

okay in my script i have it list a bunch of checkbox's.
The code is sumtin like this for listing the checkbox's with each extracted name.

PHP Code:

---


 $sql = "SELECT * FROM members WHERE trainer = 1";
  $result = mysql_query($sql) or die(mysql_error());
  while($row = mysql_fetch_array($result)) {
  echo" <tr>
    <td scope=col><input name=rem_trainer type=checkbox value=$row[username]>$row[username]</td>
  </tr>";
  } 


---

now when i check multiple box's and hit remove trainer. I want to remove each of the selected.
This is how i have it so far... tho it only works for 1 at a time.

PHP Code:

---


   if(isset($_POST['removed'])){
 echo "Removed trainer " . $_POST['rem_trainer'] ." from list.<BR>";
mysql_query("UPDATE members SET trainer = 0 WHERE username = '$_POST[rem_trainer]'") or die(mysql_error());
} 


---

any help would be greatly apperciated.

You need to append square brackets to the checkbox names. This will cause PHP to create an array when the data is posted. You can then loop through the array to execute the query for each selected checkbox:

HTML Code:

---

<input name="rem_trainer[]" type="checkbox" />

---

PHP Code:

---

if (is_array($_POST['rem_trainer'])) {
    foreach($_POST['rem_trainer'] as $trainer) {
        $trainer = addslashes($trainer); // use if magic quotes is disabled

        mysql_query("UPDATE members SET trainer = 0 WHERE username = '$trainer'") or die(mysql_error());

        echo "Removed trainer " . $_POST['rem_trainer'] ." from list.<BR>";
    }
} 


---

P.s: A little coding tip. It improves readability if you embed the PHP inside the HTML. Like this:

PHP Code:

---

<?php
    $sql = "SELECT * FROM members WHERE trainer = 1";
    $result = mysql_query($sql) or die(mysql_error()); 
?>

<?php while($row = mysql_fetch_array($result)): ?>
<tr>
    <td scope=col><input name="rem_trainer[]" type="checkbox" 
        value="<?php echo($row[username]) ?>" /><?php echo($row[username]) ?></td>
</tr>
<?php endwhile; ?>

---

Check the alternate template like while syntax. PHP also offers the same for if, for, foreach and switch. Have a look here: http://uk.php.net/manual/en/control-...ive-syntax.php

it worked. thanks.