01-12-2017, 04:19 PM
Yes, I'd like to search the users table. And yes it is filtering...and yes I want to display users who have done any of the three 
It's like this:
My users select their interests when they sign up (for instance red, green and blue). This data gets stored with their profile in the DB (in seperate columns. So a column for red, one for green one for blue, etc.).
I want other users to be able to check boxes on a form and send it (like a search query). So a user can check the box for green and red and than all the users who have that in their profile will be displayed.
I have a search form already but it lacks the ability to do some stuff I want. As I have two kinds of users and only want one kind displayed in the search.
I added two columns in the users table (lets say user1 and user2) and give them a value when people sign up (1 for yes or 0 for no). But when I add that to my search query SELECT something, something FROM users WHEN user1='1'; username '{3bc1fe685386cc4c3ab89a3f76566d8931e181ad17f08aed9ad73b30bf28114d}" . etc...it does only display the profiles of the user1 people...but that is the only thing it will do. It doesnt respond to other inputs like username, country or city. It only diplays user1 profiles no matter what words you enter into the search field.
I thought I could bypass all this by having people check some boxes with possible search terms so they can in effect only search for stuff I want them to search for.
I'm not sure of im making any sense at all though :p
It's like this:
My users select their interests when they sign up (for instance red, green and blue). This data gets stored with their profile in the DB (in seperate columns. So a column for red, one for green one for blue, etc.).
I want other users to be able to check boxes on a form and send it (like a search query). So a user can check the box for green and red and than all the users who have that in their profile will be displayed.
I have a search form already but it lacks the ability to do some stuff I want. As I have two kinds of users and only want one kind displayed in the search.
I added two columns in the users table (lets say user1 and user2) and give them a value when people sign up (1 for yes or 0 for no). But when I add that to my search query SELECT something, something FROM users WHEN user1='1'; username '{3bc1fe685386cc4c3ab89a3f76566d8931e181ad17f08aed9ad73b30bf28114d}" . etc...it does only display the profiles of the user1 people...but that is the only thing it will do. It doesnt respond to other inputs like username, country or city. It only diplays user1 profiles no matter what words you enter into the search field.
I thought I could bypass all this by having people check some boxes with possible search terms so they can in effect only search for stuff I want them to search for.
I'm not sure of im making any sense at all though :p