Hello,
Is it possible and/or advisable to use place holders to do mass deletion in a
table??
something like this:
$selquery = qq|SELECT memid FROM optin WHERE time > NOW()|;
$sth = $dbh->prepare($selquery);
$delquery = qq|DELETE FROM members WHERE memid > ?|;
$dbh->do($delquery);
while ($ids = $sth->fetchrow_hashref()) {
$sth->execute($ids->{'memid'});
}
Or is there a better way to do this
THX's
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
