Help for this page

Select Code to Download


  1. or download this
    $query = 'WHERE 1=1';
$query .= " AND state='$state'"     if ($state ne 'all');
$query .= " AND approved='$status'" if ($status ne 'all');
  2. or download this
    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');