[Resolved] using OR in mysql

[nca]

Cannot figure out why this keeps happening. I made a php script that runs this query...

SELECT count(S.ID) FROM source AS S, place AS P WHERE
S.ID=P.ID AND (P.P1 LIKE 'na') OR (P.P2 LIKE 'na') OR (P.P3
LIKE 'na') OR (P.P4 LIKE 'na') OR (P.P5 LIKE 'na') OR (P.P6
LIKE 'na') OR (P.P7 LIKE 'na') OR (P.P8 LIKE 'na') OR (P.P9
LIKE 'na') OR (P.P10 LIKE 'na') OR (P.P11 LIKE 'na') OR (P.P12
LIKE 'na') OR (P.P13 LIKE 'na') OR (P.P14 LIKE 'na')

it returns the number 165818. there is no more than 10000 records in the database?!?!

can someone tell me what i did wrong?

THANKS! 🙂

[sarahk]

try

SELECT count(S.ID) FROM source AS S, place AS P WHERE
S.ID=P.ID AND ((P.P1 LIKE 'na') OR (P.P2 LIKE 'na') OR (P.P3
LIKE 'na') OR (P.P4 LIKE 'na') OR (P.P5 LIKE 'na') OR (P.P6
LIKE 'na') OR (P.P7 LIKE 'na') OR (P.P8 LIKE 'na') OR (P.P9
LIKE 'na') OR (P.P10 LIKE 'na') OR (P.P11 LIKE 'na') OR (P.P12
LIKE 'na') OR (P.P13 LIKE 'na') OR (P.P14 LIKE 'na'))

you don't need the brackets around the individual statements but you do around all the choices.