check if_null statement don't work

Question

I simply want to check, if a query give me 'NULL' as the result.

    $check = '  SELECT some_data FROM user
                WHERE condition = my_condition LIMIT 1';
                if ( is_null($check) )
    {        
    echo "yep, it's null";
    }

But i don't get the echo. The query definitly gives me the result 'NULL'. Whats wrong?

You're not executing the query though.... `is_null($check)` will always be false, because it's a string. — ʰᵈˑ, Feb 20 '17 at 16:53
You need to execute the query, then fetch a row of results, then access the column from the result row. — Barmar, Feb 20 '17 at 16:53
stupid me! You're all right. I do the execution and fetch the results. Everything works now. — idontknowwhoiamgodhelpme, Feb 20 '17 at 16:59

score 0 · Accepted Answer · answered Feb 20 '17 at 17:00

0

Just execute the query and fetch a row of results.

answered Feb 20 '17 at 17:00

idontknowwhoiamgodhelpme

282
4
13

check if_null statement don't work

1 Answers1