I have a similar search. My table setup looks like
this
TABLE vendors:
[ id | category_id | bla | bla | city | state | zip ]
TABLE key_list:
[ id | category_id | word ]
sample data in key_list (category #1 - auto repair)
[ 1 | 1 | automobile ]
[ 2 | 1 | car ]
[ 3 | 1 | repair ]
[ 3 | 4 | autom
> How can I accomplish the following?
>
> I have a table called search,
>
> I have 3 fields, city, country, type
>
> I also have an imput box where you can type in
> a search word. What I need is, say you type in
> hotels germany, I need the search to break up
> the sentence and then search each
G'day Chris
> I have 3 fields, city, country, type
> I also have an imput box where you can type in a search word. What I need is,
> say you type in hotels germany, I need the search to break up the sentence and
> then search each 3 fields in the DB looking for a match.
> So, for example: it wou