Can someone tell me why this query isn't working please?

Question

Can someone tell me why this query isn’t working please?

$result = $connect->query( “SELECT * 
                            FROM DBdata 
                            WHERE catc !=‘121’ 
                            AND description LIKE ‘%$strm%’ 
                            OR ttl LIKE ‘%$strm%’ 
                            AND active = 1” );

THE PROBLEM - It IS LISTING ‘catc’ that = 121

I want the result it is giving, but don't want the catc items that equal 121

Thanks!

Use brackets when using `AND` and `OR` at the same time, always. — Progman, Jun 01 '19 at 16:49
You can't use curly quotes as string delimiters in PHP or MySQL. — Barmar, Jun 01 '19 at 16:49
This `“` and this `”` and these `‘’` are INVALID. Dont use a word processor to code with, use a code editor — RiggsFolly, Jun 01 '19 at 16:51

score 2 · Answer 1 · answered Jun 01 '19 at 16:50

2

Your OR is likely what's messing things up.

SELECT * FROM HWpix
    WHERE catc !='121'
    AND 
      (description LIKE '%$strm%'
       OR ttl LIKE '%$strm%')
    AND active = 1

answered Jun 01 '19 at 16:50

ceejayoz

176,543
40
303
368

THANK YOU ceejayoz!! It is working. – Steve Mackins Jun 01 '19 at 16:54

Can someone tell me why this query isn't working please?

1 Answers1