prepare("UPDATE topic_map SET status='on', screendate=NOW(), " . "screenuserid=? WHERE tptopid=? AND itemid=? AND status='new'"); $sth->execute($remote->{'userid'}, $topid, $itemid); if ($sth->rows) { $ret .= "$itemid approved.
\n"; } else { $ret .= "$itemid already acted on.
\n"; } } if ($act eq "D") { my $sth = $dbh->prepare("UPDATE topic_map SET status='deny', screendate=NOW(), " . "screenuserid=? WHERE tptopid=? AND itemid=? AND status='new'"); $sth->execute($remote->{'userid'}, $topid, $itemid); if ($sth->rows) { $ret .= "$itemid denied.
\n"; } else { $ret .= "$itemid already acted on.
\n"; } } } return $ret; _code?> # None _c?>