Hello,
Let's say my SQL query outputs following data to me:
p15 | cover | nimi
-----+---------+--------
276 | 1000000 | Name1
270 | 1000000 | Name2
319 | 1000000 | Name3
216 | 500000 | Name1
250 | 500000 | Name2
309 | 500000 | Name3
206 | 250000 | Name1
200 | 250000 | Name2
289 | 250000 | Name3
(9 rows)
And with TT I'd like to make a HTML table from this
that looks like this:
-----------+----------+-----------
Name1 | Name2 | Name3
-----------+----------+-----------
1000000 | 1000000 | 1000000
276 | 270 | 319
-----------+----------+-----------
500000 | 500000 | 500000
216 | 250 | 309
-----------+----------+-----------
250000 | 250000 | 250000
206 | 200 | 289
-----------+----------+-----------
Of course Names and other fields may change, but I'd
like to know if there's some trick to parse it, or I
just have to write bunch of IF's to find out, when
cover changes and then start new row.
Rgds,
Viljo
