2x While Schleife

[dAk0Ta]

Kann mir denn keiner weiter diese Funktionsweise erklären Nutzt denn niemand Smarty von euch

 

[dAk0Ta]

So ich habs dann selber geschaft.

Hier der Code wie es jetzt aussieht:

<?php
if($_GET['action'] == "show")
  {
    $foren = new Smarty;

    $catquery1 = mysql_query("SELECT * FROM forum_cat ORDER BY cat_id ASC");
    $catsumme = mysql_num_rows($catquery1);

    $fsumquery1 = mysql_query("SELECT * FROM forum_foren");
    $fsumquery2 = mysql_num_rows($fsumquery1);

    $cat_arr = array();
    $foren_arr = array();

    while($catquery2 = mysql_fetch_array($catquery1))
    {
        $cat_arr[] = $catquery2;
        $cat_id = $catquery2['cat_id'];

        $forenquery1 = mysql_query("SELECT * FROM forum_foren WHERE forum_catid='$cat_id'");
        while($forenquery2 = mysql_fetch_array($forenquery1))
        {
          $foren_arr[] = $forenquery2;
        }
    }

    $foren -> assign('cat_arr', $cat_arr);
    $foren -> assign('catsum', $catsumme);

    $foren -> assign('foren_arr', $foren_arr);
    $foren -> assign('anzahl', $fsumquery2);
    $foren -> display('foren_show.tpl');
  }
?>

Und hier die Template sache:

{include file="header.tpl" bez="Foren"}
<table width="100%">
<tr>
  <td class='navbodyb'><b>Es sind {$anzahl} Foren in {$catsum} Kategorien vorhanden.</b>
  </td>
</tr>
{section name=kat loop=$cat_arr}
  <tr>
    <td class='navbodyb'><font color="#804040"><b>{$cat_arr[kat].cat_name}</b></font></td>
  </tr>
  {section name=item loop=$foren_arr}
  {if $foren_arr[item].forum_catid==$cat_arr[kat].cat_id}
    <tr>
      <td class='navbodyc' height="25">
        <b>{$foren_arr[item].forum_name}</b>
        <br>
        <i>{$foren_arr[item].forum_beschreibung}</i>
      </td>
    </tr>
  {/if}
  {/section}
{/section}
</table>
{include file=footer.tpl"}