How to include 'and' operator in the following select statements?

[patelxxx]

Guy's,

The sitution is that I have 3 opions or select statements which the user selects and i need to include the AND operator in them, just in case the user selects all three options, how do I do this, I need to include the following in this code below($clause .= " and ";). Currently I'm getting an syntax error when the user selects more then one option:

$query = "select * from ".$table;
$clause = "";
 
if ($keywords1 ne '') {
    $clause .= " where ".$FORM{'category1'}." like '%" . $keywords1 . "%' ";
}
 
if ($keywords2 ne '') {
    $clause .= " where ".$FORM{'category2'}." like '%" . $keywords2 . "%' ";
}
 
if ($keywords3 ne '') {
    $clause .= " where ".$FORM{'category3'}." like '%" . $keywords3 . "%' ";
}
 

[miller]

my %where = (
    $FORM{'category1'} => $keywords1,
    $FORM{'category2'} => $keywords2,
    $FORM{'category3'} => $keywords3,
);
 
# Build Where Clauses
my @clause = ();
my @params = ();
while (my ($key, $val) = each %where) {
    next if $val eq '';
    push @clause, qq{$key LIKE CONCAT('%', ?, '%')};
    push @params, $val;
}
my $where = @clause ? " WHERE " . join(' AND ', @clause) : '';
 
my $sth = $dbh->prepare("SELECT * FROM " . $table . $where);
$sth->execute(@params) or die $dbh->errstr;
 

- Miller