You can go one better than this, even...
use PHP to construct a single SQL query
using the IN( ) comparator, ie:

<?php

// NOTE: this assumes that 0 is never a valid id; I just
// stuck it in to make the comma-delimiting come out right
$query = "DELETE FROM tablename WHERE id IN ( 0";

foreach($_POST["del"] as $val)
    $query .= ', '.$val;

$query .= ' )';

[connect]
[query]
[close connection]

?>


"Olinux" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> to make it a little better, make one connection to the
> db before you loop and then close the connection
>
> [connect]
> foreach loop
> [close connect]



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

Reply via email to