category & sub-category

Hi,
I have a mysql db with 2 tables category and sub-category and i want to create a menu from it.
I explain my self :
-----------
category:
id      : 1   ;2    ; 3
name: cat1;cat2;cat3
-----------
sub-category
id      : 1     ;2        ;3
id_act:1       ;1        ; 2
name:sub1.1;sub1.2;sub2.1
-----------
If i want to show only one table that is not problem but if i want to combinate between two tables (here is the problem)
so how can I use TBS to do this !!? I bloqued :(

Hi,

No problem.
There are two ways to do that.

1st way:
- 1 SQL statement with a join clause between tables
- use parameter \'headergrp\' to display the category.

2d way:
- 1 main block for main category, 1 sub-block for sub-category
- 1 SQL statement for each block (= 2 SQL statements)

See examples for building sub-blocks.