What's wrong with my "IS_NULL" statement?

[Moron]

(Please ignore HTML formatting)

 

if (is_null($RESULT['PBS_ACCOUNT_ID']))    {

echo "<font size=2 color=#000000 face=arial>                 <</font>";
echo "<font size=2 color=#000000 face=arial>PBS_ACCOUNT_ID</font>";
echo "<font size=2 color=#000000 face=arial>></font>";
echo "<font size=2 color=#000000 face=arial>HELLO</font>";


echo "<font size=2 color=#000000 face=arial><</font>";
echo "<font size=2 color=#000000 face=arial>/PBS_ACCOUNT_ID</font>";
echo "<font size=2 color=#000000 face=arial>></font>";


}

else

{

echo "<font size=2 color=#000000 face=arial>                 <</font>";
echo "<font size=2 color=#000000 face=arial>PBS_ACCOUNT_ID</font>";
echo "<font size=2 color=#000000 face=arial>></font>";

echo "<B>";
echo $RESULT['PBS_ACCOUNT_ID']; 
echo "</B>";

echo "<font size=2 color=#000000 face=arial><</font>";
echo "<font size=2 color=#000000 face=arial>/PBS_ACCOUNT_ID</font>";
echo "<font size=2 color=#000000 face=arial>></font>";
echo "<BR>";

}

 

If the PBS_ACCOUNT_ID field is empty, it just shows blank. Why doesn't it echo "HELLO?" Or should I be using "IS_EMPTY?"

 

[Kalland]

Hi,

 

is_null checks if the variable is equal to null. Returns true if null, false otherwise

 

You can read it here in the manual:

http://no2.php.net/manual/en/function.is-null.php

 

What you want to use is empty:

http://no2.php.net/manual/en/function.empty.php

 

[spaceman12]

NULL and blank are so very different! When the table is configured to accept null values, it wil b shown as NULL for cell with null values otherwise it is not null.

[Moron]

If the PBS_ACCOUNT_ID field is empty, it echoes: "<PBS_ACCOUNT_ID> </PBS_ACCOUNT_ID>," not "HELLO."

 

So what am I doing wrong?

 

 

[Pikachu2000]

Then it is not NULL, it is empty. There's a difference. NULL is a non-value which is equal to nothing else, not even another NULL. var_dump() the variable in question, and see what is actually in it; it's probably an empty string.