Jump to content

how can i use 3 where clauses and concat together


carlfaulkner

Recommended Posts

This is what i have but it doesnt work: WHERE isConfirmed = '1' AND category = '$category' AND CONCAT(title, description, lieuexact, city) like '%$searchQuery%' if i remove the category clause it works.i want to find all rows that are confirmed, in category 2 and title,desc, lieuexact or city fields like search field text. Any ideas....

Link to comment
Share on other sites

Please post your complete mysql_query and the specific errors it produces.

Link to comment
Share on other sites

Are you using mysql and running it in php (this is a php forum)?

Edited by niche
Link to comment
Share on other sites

You said in post 3 that you can get the clause to work. How do you know that?

Link to comment
Share on other sites

Carlos, have you checked for data in your sql resource?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...