Why wont this work?

[Liamsorsby]

Hi Been having this problem and can't get this to work although if i just search one of the queries it works. HELPPPP

 

 

$query = "select * from FUNERAL where CUSTOMER = 'Y' AND POSTCODE LIKE "%$trimmed%"

OR COUNTY LIKE "%$trimmed%"  order by POSTCODE";

[mwasif]

Try this one

$query = "select * from FUNERAL where CUSTOMER = 'Y' AND POSTCODE LIKE '%$trimmed%' 
OR COUNTY LIKE '%$trimmed%'  order by POSTCODE";

Use single quotes instead of double quotes around %$trimmed%

[DavidAM]

You are also going to need parenthesis around the two OR conditions. As it is written, you will get rows that are Customer = Y and PostCode LIKE whatever; along with rows where County LIKE whatever (regardless of the customer flag).

 

$query = "select * from FUNERAL where CUSTOMER = 'Y' AND (POSTCODE LIKE '%$trimmed%' 
OR COUNTY LIKE '%$trimmed%')  order by POSTCODE";

[mwasif]

You are also going to need parenthesis around the two OR conditions. As it is written, you will get rows that are Customer = Y and PostCode LIKE whatever; along with rows where County LIKE whatever (regardless of the customer flag).

 

$query = "select * from FUNERAL where CUSTOMER = 'Y' AND (POSTCODE LIKE '%$trimmed%' 
OR COUNTY LIKE '%$trimmed%')  order by POSTCODE";

Ohh, I missed that part.