This is off the top of my head, so possibly I'll come up with another solution later. But this is all I can think of (after thinking "It can't be done!").
You would need to have a separate form for searching. (If you don't know how to make a separate form, let me know and I'll explain it.) In the search form, create checkboxes for each of the possibilities and name them all the same -- the name of your field. They would look something like this:
Code:
<input type="checkbox" name="Type" value="Cows">Cows<BR>
<input type="checkbox" name="Type" value="Horses">Horses<BR>
<input type="checkbox" name="Type" value="Cats">Cats<BR>
<input type="checkbox" name="Type" value="Dogs">Dogs<BR>
<input type="checkbox" name="Type" value="Birds">Birds
In db.cgi, sub query, after
local (%sortby);
add
Code:
foreach $col (@db_cols) {
if ($in{$col} =~ /~~/) {
$in{$col} =~ s/~~/|/g;
$in{'re'} = 1;
}
}
You also will want to make a little change in sub parse_form.
after
if ($value eq "---") { next PAIR; }
add
unless ($value) { next PAIR; }
Now, understand that like most of the things I give folks, this is a guess. I have used the change in parse_form and I tested the new lines for sub query on my home computer. I think it should work.
------------------
JPD
