my $q_state  = $dbh->quote($state);
my $q_status = $dbh->quote($status);

$query = 'WHERE 1=1';
$query .= " AND state=$q_state"     if ($state ne 'all');
$query .= " AND approved=$q_status" if ($status ne 'all');