<&| txtable, tx => $row &>
% $sthi->execute($row->{'textid'});
+% my $anyused = 0;
% while (my $rowi= $sthi->fetchrow_hashref()) {
<tr><td>Used for:</td><td><% $rowi->{'emailaddr'} |h %></td></tr>
+% $anyused++;
+% }
+% if ($anyused) {
+<tr><td colspan=2>Not currently in use</td></tr>
% }
</&>
<pre>
my $tdeleteq = $dbh->prepare("DELETE FROM addresses WHERE textid = ?");
$tdeleteq->execute($textid);
+my $odeleteq = $dbh->prepare("DELETE FROM addresses WHERE emailaddr = ?");
+
my $tinsertq = $dbh->prepare("INSERT INTO addresses (emailaddr, textid)".
" VALUES (?,?)");
my $tlistq = $dbh->prepare("SELECT * FROM config");
$tlistq->execute();
while (my $row = $tlistq->fetchrow_hashref()) {
if ($ARGS{"u_".hquote($row->{'emailaddr'})}) {
+ $odeleteq->execute($row->{'emailaddr'});
$tinsertq->execute($row->{'emailaddr'}, $textid);
}
}