Re: [phplib] RESOLVED Table widget hides columns with null first row value From: Chris Stankevitz (chris <email protected>)
Date: 07/16/00

Although it does appear that PHPLib's table widget drops the entire column
when the first row has a null value, Jesse's IFNULL() idea (quoted below) is
a great workaround.

Thanks Jesse!

Chris

At 06:36 AM 7/16/2000 -0400, Jesse Swensen wrote:
>on 7/16/00 3:02 AM, Chris Stankevitz at chris <email protected> wrote:
>
>> <?php
>> require("table.inc");
>>
>> $q = new DB_Lobo;
>> $t = new Table;
>>
>> $q->query("SELECT * FROM lobo;");
>> $t->show_result($q);
>> ?>
>>
>> This query (mysql) returns about 100 rows, with columns like first_name,
>> homepage_url, primary_email, etc. Only those columns whose values are not
>> null in the first row appear! (Verified with different queries.) My mysql
>> client shows all the columns, so I assume PHPLib is getting them.
>
>This may be more of a HTML table thing. If you don't put anything in the
>table cell, it is not displayed. No border, etc... So, try this:
>
>$sql = "
> SELECT
> IFNULL(col1, '&nbsp;'),
> IFNULL(col2, '&nbsp;'),
> IFNULL(col3, '&nbsp;')
> FROM
> lobo
>";
>
>$q->query($sql);
>
>This will put a non breaking space (nbsp) in the cell if colx is null,
>otherwise colx.
>
>Hope I have understood the problem and this helps...
>
>--
>Jesse Swensen
>swensenj <email protected>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: phplib-unsubscribe <email protected>
>For additional commands, e-mail: phplib-help <email protected>
>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>