Database search filter

[LBC]

Hey Mudmin,

thank you for your response. I have added the if !in_array stuff to those lines, but that is not the problem.

I think I need to alter the query somehow into something like:

Code:

SELECT * FROM users WHERE project ='1' AND small_animals LIKE '{3bc1fe685386cc4c3ab89a3f76566d8931e181ad17f08aed9ad73b30bf28114d}" . $name . "{3bc1fe685386cc4c3ab89a3f76566d8931e181ad17f08aed9ad73b30bf28114d}'

so that when the project box AND the small animals box are checked I only get the results from users that have the project status and the small animals interest...and not any volunteers that have also indicated an interest in small animals.

I just dont seem to get how and where I need to add that code. So if you have any ideas on that, that would be awesome