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.
|
|
Posting in progress.
Please wait...
|