Categories > TinyButStrong general >

2D table asked another way

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: David Christensen
Date: 2003-12-18
Time: 13:15

2D table asked another way

Let me ask my question another way and fill in some things I know.

I am able to print my table to a point using a serial MergeBlock format.  I am able to print columns 2 through 14 with the correct data, but column 1 is giving me trouble.

Column 1 is the "GROUP BY" field in the query which selects all the data.  Each row is made up of 15 columns, a single, unique entity in column 1 with the 14 others all with the same column name in the db with column 1 as the common factor.

I can't figure out which syntax to use to get the entire row of data to print correctly.  I thought maybe the column/serial format would work, but I can't seem to get column1 to print out using either a multi-demensional array nor a direct MergeBlock MySQL query.
By: David Christensen
Date: 2003-12-18
Time: 13:40

Re: 2D table asked another way

In trying some other techniques, I added a separate MergeBlock with only the column 1 data and gave it a different BlockName in the HTML.  The result was an almost hit, except that the ordering was off by 1.  Columns 2 through 14 were still correct, just column 1 wanted to put the first record at the bottoma nd start off with record two.

Amazingly enough, if I change the order of the MergeBlock's in the PHP script, it works!  If I put the Column 1 MerBlock after the MergeBlock for 2-14 columns, it magically falls into place.

Any ideas why this would work and why the order would be dependant?
By: David Christensen
Date: 2003-12-18
Time: 14:30

Re: 2D table asked another way

Here's another one to scratch your heads over:

I have the table template setup with two row of alternating color.  First row having a white background and the next having a light grey.

For some reason, when the code is sent to the browser, the rows are reversed.  Grey on top and white below.  I've double checked the template, and row 1 bgcolor="#FFFFFF" and row 2 bgcolor="#CCCCCC".  I'm REALLY confused now!
By: Skrol29
Date: 2003-12-18
Time: 17:22

Re: 2D table asked another way

Hello David,

Could you send or post a draw of you problem because I have trouble to figure it out.