[Mikehive]

I can't figure out the most effective way to do this. I'm trying to write a script that will delete users in bulk from a forum; the idea is that the user can check the boxes for each user to remove and then the script clears them all out of the database table.

At the moment each checkbox is given the user's ID as its 'name'. Is there a way to make a query out of this that simply deletes all the users that have been checked, without testing every user one-by-one to see if their value is 'on'? Or is there a better way to set up such a script? Please, any logistical or script advice would be very welcome.

Thanks in advance

[Keith]

PHP Code:

<?php



foreach ($_POST['delete'] as $user_id)

@mysql_query("DELETE FROM users WHERE user_id = '" . $user_id . "'");



?>

That's assuming the checkboxes are named "delete"...

Oh yeah, this is how you'd build the checkboxes from the database. The "name" input would be the same, it's the values that would change from user to user:

Code:

<!--
Use the format:
<input type="checkbox" name="delete" value="USER_ID"> USER_NAME
--!>

<input type="checkbox" name="delete" value="1"> Hank
<input type="checkbox" name="delete" value="2"> Jim
<input type="checkbox" name="delete" value="4"> Bob
<input type="checkbox" name="delete" value="5"> Arnold
<input type="checkbox" name="delete" value="7"> Steve

[infinitylimit]

Keith's code is suppose to work, but it if doesn't try putting a [] after the delete so it will be name="delete[]" and if that doesn't work try putting a unquie index for each one in there.

[Keith]

Ohhh yeah yeah yeah... I totally forgot about that. Oops oops oops...

Code:

<input type="checkbox" name="delete[]" value="1"> Hank
etc...