Why is one condition being omitted ?

[iPixel]

Here's my SQL query

 

"SELECT * FROM syx_ad WHERE firstname LIKE '%$q%' OR lastname LIKE '%$q%' AND status = 'Active' LIMIT 20"

 

the LIKE's are satisfied but it doesnt bother checking for status.. results still display the user if his/hers status is Inactive... am i just doing something wrong?

[mikesta707]

seems right to me =/ make sure You have all your column names and stuff right. Maybe try setting Active to a variable name and checking if status='$active' or something

[iPixel]

Tried the variable way also... no dice, and yes all my column names are correct.

**GRR** annoying lol.

[kickstart]

Hi

 

Do you want:-

 

"SELECT * FROM syx_ad WHERE firstname LIKE '%$q%' OR (lastname LIKE '%$q%' AND status = 'Active') LIMIT 20"

 

or

 

"SELECT * FROM syx_ad WHERE (firstname LIKE '%$q%' OR lastname LIKE '%$q%') AND status = 'Active' LIMIT 20"

 

Default precedence it will do the AND first. However it is best to use brackets to make the logic more obvious when you next have to touch the code.

 

All the best

 

Keith

[iPixel]

Here's the logic to what i want.

 

Basically the search has to be %LIKE% either firstname or last name, that doesnt matter.. just status HAS TO BE ACTIVE

 

"SELECT * FROM syx_ad WHERE status = '$stat' AND firstname LIKE '%$q%' OR status = '$stat' AND lastname LIKE '%$q%' AND status = '$stat' LIMIT 20"

[Mchl]

So you want

status = '$stat' AND (firstname LIKE '%$q%' OR lastname LIKE '%$q%')

 

Courtesy George Boole