syntax issue

[jenniferG]

we want to make a decision  based upon whether a column is null or

not. The columns are date columns and contain '0000-00-00';

Is this the correct syntax?

 

if(column ===NULL){do something;} else {do something else;}

 

Thanks,

 

Nadine

[Daniel0]

Just check if it's empty.

 

if(empty($whatever))
{
echo "It's empty or null";
}
else {
echo "It isn't empty or null";
}

 

That should do.

[trq]

If the columns contain '0000-00-00' then it makes sense you'll need to check for that. Also, your best to do this in your query if possible.

[Daniel0]

If it contains 0000-00-00 then it isn't null, but I'm not sure what she means.

 

Btw, how come your username says Jennifer, but you sign your post Nadine? o_O