I have a simple application that lists and offers to search members in a simple table. The search form works fine if you're searching by name, city, state, etc. One field of the table lists member's interests. That field has the information entered in the following way:
1,2,3,7,22,30
where each number corresponds to an interest. Example:
1 = oak
2 = maple
3 = elm
7 = willow
etc. The table can't be provided to me in any other way so I'm stuck with this. What I need to be able to do is search for the individual interests in that field. What I'd like to do is have, on the search form, checkboxes for each of the interests so that a user could check the ones he wants to pull in the search.
How can I do this? Thanks.
1,2,3,7,22,30
where each number corresponds to an interest. Example:
1 = oak
2 = maple
3 = elm
7 = willow
etc. The table can't be provided to me in any other way so I'm stuck with this. What I need to be able to do is search for the individual interests in that field. What I'd like to do is have, on the search form, checkboxes for each of the interests so that a user could check the ones he wants to pull in the search.
How can I do this? Thanks.
Last edited: