0 AND is_numeric($_GET['knk'])){
$kapitel = $_GET['knk']+3; # +3 da Kapitel 1 mit Container 4 anfängt im HTML
$smarty->assign('open_kap', $kapitel);
}
$zaehler = 0;
$outer_loop = array();
$result = $db->query( $query)
or die ("Cannot execute query");;
while ($row = $result->fetch_array()){
unset($value2);
$zaehler = $zaehler+1;
if(is_numeric(substr($row['knk'],0,1))){
$query1 = "SELECT number, question
FROM knk_fa
WHERE headline ='$row[knk]'
";
}else{
$query1 = "SELECT knk number, ueberschrift question
FROM knk
WHERE knk like '$row[knk].%'
and ueberschrift != 'EXTRAKT'
";
}
#echo $query1."
";
$result1 = $db->query( $query1 )
or die ("Cannot execute query1");;
while ($row2 = $result1->fetch_array()){
if(is_numeric(substr($row2['number'],0,1))){
# wenn knk mit Zahl beginnt
$knk_num = 1;
}else{
# wenn knk ein Character hat "vorwort"
$knk_num = 0;
};
#$ueberschrift = trim(str_replace("$row2[number]", "", $row2['question']));
# echo "
# knk: $row2[number]
# knk_sub: $row2[0]
# knk_num: $knk_num
# ueberschrift_sub: $row2[question]
# ";
$row2['knk'] = $row['knk'];
$row2['knk_sub'] = $row2['number'];
$row2['knk_num'] = $knk_num;
$row2['ueberschrift_sub'] = $row2['question'];
$value2[] = $row2;
}
$row['zaehler'] = $zaehler;
$row['inner'] = $value2;
$value[] = $row;
}
#echo "";
#print_r($value);
#echo "
";
#exit;
$smarty->assign('outer_loop', $value);
$smarty->display("$template/$templatename");
?>