From: "Adam Williams" <[EMAIL PROTECTED]>
> This is my SQL query:
>
> "SELECT seriesno, governor, descr, boxno, year, eyear, docno
> from rg2 WHERE seriesno = '$_POST[seriesno]' and governor matches
> '*$searchterm*' or descr matches '*$searchterm*'";
Looks like you're doing the equivilent to a M
This is my SQL query:
"SELECT seriesno, governor, descr, boxno, year, eyear, docno
from rg2 WHERE seriesno = '$_POST[seriesno]' and governor matches
'*$searchterm*' or descr matches '*$searchterm*'";
So as you can see, its gonna need some work to make it do fulltext
searching of the descr field
Explode the kewords list. I have mine explode the keyword and search
the description field. It CAN limit it by category AND/OR by Vendor.
But this will do the trick without the limiters.
$keyword = $_POST[keyword];
$keywords = explode(" ", $keyword);
// so you can search for each word they enter
From: "Adam Williams" <[EMAIL PROTECTED]>
> CPT John W. Holmes wrote:
> > From: "Adam Williams" <[EMAIL PROTECTED]>
> >
> >>I am selecting a field in a database called description for keyword
> >>searching. The field contains names of people, states, years, etc.
When
> >>someone searches for say "
I'm doing a fulltext search.
CPT John W. Holmes wrote:
From: "Adam Williams" <[EMAIL PROTECTED]>
I am selecting a field in a database called description for keyword
searching. The field contains names of people, states, years, etc. When
someone searches for say "holmes north carolina" the quer
From: "Adam Williams" <[EMAIL PROTECTED]>
> I am selecting a field in a database called description for keyword
> searching. The field contains names of people, states, years, etc. When
> someone searches for say "holmes north carolina" the query searches for
> exactly that, fields which have "ho