[PHP] NULLS vs Empty result in PHP

[Dan Shirah]

Morning!

Just a quick question.

Say I have a column in my database that could contain NULLS, empty spaces,
or an actual value.

If I do:

$my_query = "SELECT my_column FROM my_database WHERE 1 = 1";
$my_result = ifx_query($my_query, $connect_id);

while($row = ifx_fetch_row($my_result)) {
  $my_column = trim($row['my_column']);

  if ($my_column != "") {
   echo "Test";
  }
}

The way PHP assigns the query results to the $my_column variable, wouldn't;
if ($my_column != "")  not do anything for the rows that contained NULLS or
empty spaces?