Some one here who can explain why this query is working fine:
Code:
$findThis = "testing";
$inCategory = "cat1";
SELECT *
FROM products
WHERE products.Desc LIKE '%$findThis%'
AND category= '$inCategory";
It returns the correct info, from cat1.
But when I want to search in more product fields (in this case also the Title), and when I set the inCategory to an other value it still shows the info from cat1
Code:
$findThis = "testing";
$inCategory = "cat2";
SELECT *
FROM products
WHERE products.Desc LIKE '%$findThis%'
OR products.Title LIKE '%$findThis%'
AND category= '$inCategory";
I have also tested this:
Code:
SELECT *
FROM products
WHERE products.Desc LIKE '%$findThis%' || products.Title LIKE '%$findThis%'
AND category= '$inCategory";
But I get the same results as the 2nd query.
For some reason the AND does not work correct!
Anyone here who can show me what the correct syntax is?
Recent comments
23 hours 29 min ago
23 hours 35 min ago
1 day 4 hours ago
1 day 11 hours ago
1 day 12 hours ago
1 day 13 hours ago
1 day 17 hours ago
2 days 16 min ago
2 days 4 hours ago
2 days 5 hours ago