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

Jesse,

You bring up a good point! I forgot about that and should have been more
specific.

If the first row has [first_name = null], then the first_name column will
not show up. Even if the other 99 rows have first_name. No column heading,
nothing. The column disappears.

OTOH, if the first row contains data in the dob_dt column while the other 99
have [dob_dt = null], the column *is* displayed, with a heading, and the
other rows simply get an empty cell.

If no one out there has seen this, or if people agree that this does not
happen for them, i'll assume it's something lame i'm doing which will go
away soon :)

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>