Apologies for the vauge title. I’m trying to build a search database of services for children. Within my database there are a number of INT fields which represent different service types. E.g if a service is a childminder then a ‘1’ is entered in the $childminder field if not it is 0 (NULL).
My form is a simple wild card and area search - http://pastie.org/private/xcgurjmysgqyhik46xvyka, yet I’d really like to allow the $sql_result to search for any INT fields (that have a ‘1’ in them) to be shown in the results as well, so that if someone types childminder all rows with the childminder INT column marked ‘1’ will show up.
I’d also like to add a simple pagination as well yet I’m getting v.confused - appreciate any help out there!
