Table with dynamic number of rows

Hi Skrol,

I saw your example called 'Merge table with dynamic number of columns' in the t&t section.
My question:
Can I used the same approach for a table with dynamic number
of rows where the data is coming from a three dimensional array?
I have an 3D-array which I need to display in a table, however
for the 2nd dimension I have varibale number of entries. Since I don't know how many, the template must be able to display a table with
variable number of rows.

Thanks in advance,
Marcus

Hello Marcus,

I've moved you post here.

It maybe work if you use sub-blocks. First merge the main block with your array without sub-row.
Then merge sub rows on a sub-block (use dynamical query for Php array). If you need to display them horizontaly on a table, you will probably need 2 merges : one for columns names (keys) and another for column values. This is the same technic as for dynamic queries.

But I think you won't be able to merge both main-rows and sub-rows in the same <table> because an Html is supposed to have the same number of columns for each row.

Hi Skrol,

First of all to thanks for your outstanding and fast support.
For a free program this is really excellent.

I tried several stuff this afternoon to make it work, but to no avail.
However I could simplify my array a bit. It's now 2D and consists
of a dynamic number of rows and columns. One example how it
could look like is:
As written above the number of rows and columns is not fix.
As you can see, in this example it has 3 rows and each row has a varying number of columns. Now I need to display the values the following way (only first row for example):

<tr>
<td>Managers</td><td>Mike Duuley</td><td>Stan Cooper</td><td>James Gunder</td>
</tr>
.
.
.

Is there some code/example available on how I could do that?
I could also change the keys that represent the rows (FQA, PEN...) to numbers, like 0,1,2...

Any help appreciated!
Thanks again,
Marcus


</tr>

Hello Marcus,

Could you provide an example of how the complete table should be structured. If the table is made of simple rows like your example, then you'll have a various number of columns in the same table, which is not "html" clean.

Hi Skrol,

Sorry for not being precise enough!

For each row I would need to make a new table, ie one table for
one row. So the whole array would be displayed like this:


However, since the array is dynamic I need as many tables repeated as rows and in each table a dynamic number of columns (as you can see from my array structure.

Hope this helps you,
many thanks again,
Marcus

Hello Marcus,

Here is a solution that works.
It uses a sub-block with a dynamic query for array.

Html:
Php: