How does one refer to empty cells in mysql?

drayarms · May 31, 2011, 11:59am

I have tried the following variations but non works

if($row[‘relation’] = “” ){

if($row[‘relation’] = ‘’ ){

if($row[‘relation’] = NULL ){

if($row[‘relation’] IS NULL ){

if(strlen($row[‘relation’]) = 0 ){

So how would one refer to a cell that is empty?

lothop · May 31, 2011, 12:41pm

if($row[‘relation’] != “” ){

or if(isset($row[‘relation’])){
Dunno about isset one for sql.

NastyLucas · May 31, 2011, 2:13pm

I believe it depends on the formatting of the field, I would assume “” or null would find an empty field, but perhaps you have whitespace. Try " ".