When I do something like this, I tend to do the data setup within the
PHP itself. Keeps the template simple.
$res = $DB->query('SELECT * FROM tbl, cat_tbl WHERE tbl.cat_id =
cat_tbl.cat_id ORDER BY cat_id');
while($r = $res->fetchRow())
{
$data[$r['cat_name']][] = $r;
}
$tpl->assign('data', $data);
and in the template:
{foreach key=cat item=d from=$data}
Category: {$cat}
{foreach item=entry from=$d}
{$entry.col_name}
{/foreach}
{/foreach}
gawan wrote:
I finally got time get back to this problem.
I tried something like this (cat_id is here genre_id and
cat_description is
genre_description):
{$foo eq ''}
{foreach from=$db_result item=current key=PISBN}
{if $foo ne
$current->genre_id}{$current->genre_description}{/if}
{$foo eq $current->genre_id}
{/foreach}
I kind of see why this will not work, but I can't figure out how this
should
be written...!?
thanks for any further advice
gawan
----- Original Message -----
From: "Tim Burden"
To: "gawan" ;
Sent: Tuesday, January 07, 2003 2:25 AM
Subject: Re: [SMARTY] How do I group db results by category with Smarty?
>SELECT * FROM table1,table2 WHERE table1.cat_id = table2.cat_id AND text
>LIKE $q GROUP BY table1.cat_id.
>
>Then in the template, set $foo = '', loop through this result set,
setting
>$foo = $cat_id at the end of each iteration, then print
cat_description if
>$foo != $cat_id
>
>would be one way.
>
>----- Original Message -----
>From: "gawan"
>To:
>Sent: Monday, January 06, 2003 6:33 PM
>Subject: [SMARTY] How do I group db results by category with Smarty?
>
>
>
>>I have a table with data and an other table with category information
for
>>the data
>>
>>table1: id, title, text, cat_id
>>table2: cat_id, cat_description
>>
>>It is easy to display data from table 1 with smarty. I fetch the data as
>
>an
>
>>object array an display these with a smarty foreach loop.
>>But I don't know how to display the data organized by category and use
the
>>gategory name (cat_description as a caption for each group).
>>(The number of categories in each case after a search is unknown, as are
>
>the
>
>>number of rows in each gategory, if any)
>>Does anyone know an example of using Smarty to display hierarcical data
>
>this
>
>>way. I was hoping to render the data like this:
>>
>>Caption for category one (from cat_description)
>> A row of data
>> A row of data
>> A row of data
>>Caption for category two
>> A row of data
>> A row of data
>> A row of data
>>Caption for category three
>> A row of data
>> A row of data
>> A row of data
>>:
>>etc
>>
>>Any advise on how to start tackling this challence?
>>thank you very much
>>
>>gawan
-- -
Kelly Cochran
http://www.trolans.net/
--
Smarty General Mailing List (
http://smarty.php.net/)
To unsubscribe, visit:
http://www.php.net/unsub.php
