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

Hi, of course. I am more puzzled on how to build the tables in the php-part, so that section/foreach can be used easily. Sorry for beeing unclear. /Bjørge On Wednesday 06 December 2006 15:30, Monte Ohrt wrote: > 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! -- Bjørge