I'm trying to use serial with sub-blocks:
$TBS->MergeBlock('main','adodb',"SELECT * from category ORDER BY id");
$TBS->MergeBlock('sub','adodb',"SELECT prod_name FROM product WHERE category='%p1%' ORDER BY RAND() LIMIT 4");
I can get the sub-block to display in a single column:
<table>
<tr>
<td style="font-weight:bold">[main.cat_name;block=table]</td>
</tr>
<tr>
<td>[sub.prod_name;block=tr;p1=[main.cat_name]]</td>
</tr>
</table>
|
But I can't get it to work with serial:
<table>
<tr>
<td colspan="4" style="font-weight:bold">[main.cat_name;block=table]</td>
</tr>
<tr>
<td>[sub;block=tr;serial][sub_1.prod_name;block=td;p1=[main.cat_name]]</td>
<td>[sub_2.prod_name;block=td;p1=[main.cat_name]]</td>
<td>[sub_3.prod_name;block=td;p1=[main.cat_name]]</td>
<td>[sub_4.prod_name;block=td;p1=[main.cat_name]]</td>
</tr>
</table>
|
How can I display the sub-block in four columns instead of one?