RE: [PHP-DB] deleting multiiple records from database

echo out the sql just before you execute it when doing the delete, ensure that the values that you are expecting to be deleted are being deleted bastien

From: "Adil" <aasheer@draftnet.com> To: php-db@lists.php.net Subject: [PHP-DB] deleting multiiple records from database Date: Wed, 13 Oct 2004 16:11:36 -0400 Hey everyone, I'm trying to delete multiple records from a database using PHP. I have a file list page which shows each entry in the database with a checkbox next to it. At the bottom of the page is a "Delete" button. A user should be able to check as many items on the file list and hit delete which would cause all checked items to be wiped from the database. Unfortunately I'm running into really erratic behavior with this. First the page worked fine on Mac(in the Safari browser) but not on IE on any OS. Now I can only delete the first time in the list but ONLY in Safari once more. As far as the code goes what I'm doing is retrieving each record from the database and assigning the "value" attribute of each checkbox the unique id from the database. From that point on, when a checkbox is checked and the delete button is pressed, I push each checked unique id into an array and then call a function that cycles through the array and deletes each database entry. The last step is a simple page refresh. I'm posting some of the more relevant sections of the code I've used below: echo "<form action=\"{$_SERVER['PHP_SELF']}\" method=\"post\">"; //form declaration echo "<input type=\"submit\" value=\"Delete\"value=\"Submit\">"; //The delete button

    <td><input type=\"checkbox\"
value=\"{$row['upload_id']}\"></input><br/></td>";        //This is what the

checkbox is coded as

    $stack[] = $row['upload_id'];        //This should get pushed into an

array called stack when the delete button is hit(and it does when I echo it out, so this part works) echo "</form>"; if (isset($_POST['stack'])) {

    deleteFiles();        //This checks to see if the array stack is not

empty, and if not it calls this function which is declared as shown below. } function deleteFiles() {

    foreach($_POST['stack'] as $i) {        //This should work but I can't

tell if it is or isn't

         mysql_query("DELETE FROM uploads WHERE upload_id =" . "$i");
    }
   header("Location: http://" . $_SERVER['PHP_SELF']);        //forces a

page refresh to show the file list without the items that were deleted. } I appreciate any help I can get on this. Thank you Adil. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php