PHP Check for NULL

Question

Here is the below Code    query   mysql query  SELECT   FROM tablex     if   result   mysql fetch array  query         if   result  column      NULL    print   lt input type  checkbox    gt          else   print   lt input type  checkbox  checked   gt          If the values are NOT NULL i still get the uncheked box  Am i doing something wrong from above  shoudnt  result  column      NULL work   Any Ideas

User · Answer

I think you want to use  mysql fetch assoc  query    rather than  mysql fetch row  query    The latter returns an normal array index by integers  whereas the former returns an associative array  index by the field names

User · Answer

How about using   if  empty  result  column

User · Answer

Sometimes  when I know that I am working with numbers  I use this logic  if result is not greater than zero    if    result  column   gt 0

User · Answer

Use is null or     operator   is null  result  column      result  column       NULL

User · Answer

Make sure that the value of the column is really NULL and not an empty string or 0

[php] PHP Check for NULL

Examples related to php

Examples related to mysql

Examples related to null