Re: [SMARTY] How do I group db results by category with Smarty?

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}
  <tr>
    <td colspan="10">{if $foo ne
$current->genre_id}{$current->genre_description}{/if}</td>
  </tr>
  <tr>
     <!-  printing row data here -->
  </tr>
  {$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" <tim@xxxxxxxxxxxxxx>
To: "gawan" <mail@xxxxxxxxx>; <smarty-general@xxxxxxxxxxxxx>
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" <mail@xxxxxxxxx>
> To: <smarty-general@xxxxxxxxxxxxx>
> 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
> >
> >
> > --
> > Smarty General Mailing List (http://smarty.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> --
> Smarty General Mailing List (http://smarty.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>


-- 
Smarty General Mailing List (http://smarty.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php