Smarty

[Rumborak]

Hi all,

I´d wonder how it is possible to show the result of a query on two tables using smarty. For example if I have one table that contains groups an a second table that contains articles (or users or whatever). The second table contains a foreign key refering to the groups-table.

So I do a query on the first table: "SELECT * FROM groups"; then a query on the second table: "SELECT * FROM users WHERE group_id = [groups.id]"

Both the amount of groups and users per group can vary. How can I display the result on my page?