Hi,
Just modify letter_search subroutine in LetterSearch plugin which I sent you:
....
my $db = $home->{cgi}->{db};
my $table = $DB->table($db);
$table->select_options("Order by $column",$limit);
my $cond;
my $words = [split /\s/,$letter];
$cond = GT::SQL::Condition->new ();
$cond->{bool} = 'OR';
foreach (@$words) {
($_) and $cond->add($column,'LIKE',"%$_%");
}
my $sth = $table->select ($cond);
my $hits = $table->hits();
....
And then create a link db.cgi?do=search_results&db=<%db%>&let=black%20white&col=column_name or you can create a form for searching words.
Hope that helps,
TheStone.
B.
Just modify letter_search subroutine in LetterSearch plugin which I sent you:
....
my $db = $home->{cgi}->{db};
my $table = $DB->table($db);
$table->select_options("Order by $column",$limit);
my $cond;
my $words = [split /\s/,$letter];
$cond = GT::SQL::Condition->new ();
$cond->{bool} = 'OR';
foreach (@$words) {
($_) and $cond->add($column,'LIKE',"%$_%");
}
my $sth = $table->select ($cond);
my $hits = $table->hits();
....
And then create a link db.cgi?do=search_results&db=<%db%>&let=black%20white&col=column_name or you can create a form for searching words.
Hope that helps,
TheStone.
B.