Hier mein php code:
PHP-Code:
<?
$sql = "SELECT id,mainid,name,beschreibung,typ FROM gs_boards WHERE typ = 1";
$gs_boards = mysql_query($sql) or die("Error using mysql_query($sql): ".mysql_error());
$boards = array();
while ($board_row = mysql_fetch_assoc($gs_boards)) {
$boards[] = $board_row;
}
$sql = "SELECT id,mainid,name,beschreibung,typ FROM gs_boards WHERE mainid = '".$boards[$i][id]."'";
$gs_unterboards= mysql_query($sql) or die("Error using mysql_query($sql): ".mysql_error());
$unterboards = array();
while ($unterboards_row = mysql_fetch_assoc($gs_unterboards)) {
$unterboards[] = $unterboards_row;
}
$smarty->assign('boards', $boards);
$smarty->assign('boards2', $unterboards);
$smarty->display('board.tpl');
?>