Re: NULLS vs Empty result in PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>
>  From reading the other responses to this thread, it seems that you want
> to
> "skip" or "exclude" rows in the results where my_column === null.
>
> If this is correct, why not do it in the SELECT statement to begin with?
>
> $my_query = "SELECT my_column FROM my_database WHERE my_column IS NOT
> NULL";
>
> That should do it.
>

I want to exclude the rows that might be NULL, "" (empty), or "        "
(empty series of spaces)

>From all of the input so far, it seems that using trim() on the variable and
then use empty() is the best way to pick all three types up.

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux