Re: [SMARTY] Newbie Q: was recursive loops, how to do w/Smarty?

Use a nested {section} or {foreach} loop in the template. Bjørge Solli wrote:

Hi I'm a beginner at this, but love the concept. Use table sized spoons when answering.. I have something that I normally would code like this: <loop1> SQL-query1 ... <loop2>

    SQL-query2, using the result of SQL-query1 as a part of the query
    ...

</loop2> </loop1> How to do this best with Smarty? The data is ordered something like this: TABLE1: fields: id, info1, info2,... TABLE2: fields: id, table1-ref-id, date, info1, info2,... One entry in TABLE1 has many (thousands) referencing entries in TABLE2. I generally have thousands of entries in TABLE1, each having thousands of entries in TABLE2, so this generates a lot of data to be shown - hence I use the info-fields to select the desired output area. Another small Q: I also use SQL-SELECTs with LIMIT, to limit the size of the page, but I find this to be a part of presentation, not business logic. Is the best way to use .total and .iteration for this? My code looks so much nicer using Smarty, many thanks to all developers!