jerastraub Posted October 17, 2006 Share Posted October 17, 2006 I am using the following select statement:[code]$result = mysql_query("SELECT count(*) from sierratrdingpost_items WHERE PrimaryDepartmentID = '154' AND prodSku LIKE '%$search%' || prodName LIKE '%$search%' || prodDesc LIKE '%$search%' || prodBrand LIKE '%$search%' || UniqueprodSku LIKE '%$search%' || prodPrimCat LIKE '%$search%' || prodSecCat LIKE '%$search%'");[/code]For some reason it isn't recognizing the [code]PrimaryDepartmentID = '154'[/code]in this statement. As I am running a database that has mens, women's and childrens clothing. However for this site search I just want to pull the men's clothing which has a PrimaryDepartmentID of 154.Can you tell me what i am missing here, I have messed with it and just can't get it to work right. Quote Link to comment Share on other sites More sharing options...
obsidian Posted October 17, 2006 Share Posted October 17, 2006 you've got to put parenthesis around the groupings in your where clause to tell SQL what presidence you want it to take:[code]SELECT count(*) from sierratrdingpost_items WHERE PrimaryDepartmentID = '154' AND (prodSku LIKE '%$search%' || prodName LIKE '%$search%' || prodDesc LIKE '%$search%' || prodBrand LIKE '%$search%' || UniqueprodSku LIKE '%$search%' || prodPrimCat LIKE '%$search%' || prodSecCat LIKE '%$search%')[/code]notice the parenthesis around all the sku checks. this will assure that ONE of the OR clauses is true, but the AND is always required.good luck Quote Link to comment Share on other sites More sharing options...
jerastraub Posted October 17, 2006 Author Share Posted October 17, 2006 Tks, that works perfect!!!1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.