Search page pulling in incorrect data
I have a search page that I am working on. See previous post 'Update page to modify database' for basic info. Created back end, works great.
The fields that are having an issue are ones that are using an array. This is probably simple as I see what it is doing.
Will use one specific field. Specialties. They can be numbered from 1 to about 25.
record 1 has 1,3,5 for entries
record 2 has 1, 7, 13 for entries.
When I search for specialty 1 both records come up.
When I search for 7 #2 comes up.
5 #1 comes up
but.... when I search for 13 or 3 I get both. I assume it is because they both have numbers in common. I also assume somewhere there should be something that tells it to use the comma separator to split it up.
Here is the comparison list line from the results page
or is the problem on the search page?
Any help would be appreciated.