query("SELECT * FROM mitarbeiter WHERE aktiv>0 ORDER BY name"); while($row = $temp->fetch_assoc()) { $tempma[$key]['id'] = $row['id']; $tempma[$key]['name'] = $row['name']; $tempma[$key]['typ'] = $row['typ']; $key++; } $template->assign('tempma', $tempma); $template->assign('content', 'tpl/test0815.tpl'); ?>