mysql delete loop

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



displayexpt.php?softID=$softID displays a checkbox
list of experts for a given piece of software. The
admin needs to select each user he wants to delete.
This is then posted to deleteexpt.php?softID=$softID,
which must delete users from the apliexpert table with
a statement like this:
DELETE FROM apliexpert WHERE id=$id AND
softID=$softID;

Given more than one expert may need to be deleted I
think I need some kind of loop that makes a passes a
different delete statement for each $id. To handle the
multiple $ids I have the following for loop:
##### code ########
for ($index = 0; $index < $total_records; $index++) {
    if (isset($id[$index])) {
         $sql2 .= "Clave = \"" . $id[$index] . "\"";
    }
##### end ########

I've tried changing $sql2 to:
"DELETE FROM apliexpert WHERE id = \"" . $id[$index] .
"\"";

but the loop doesn't work; it deletes the first record
and then stops.

thanks :))

J

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux