Dan Shirah wrote:
> 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?
>
>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.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
