query("SELECT * FROM tourenliste WHERE tour='".$_GET['tour']."' ORDER BY id"); $key=0; $zahl=0; while($trow = $htour1->fetch_assoc()) { $row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$trow['fahrer']."' AND aktiv=1"); if($row_fahrerx['num_rows'] >0) { $fahrer=$trow['fahrer']; $hinfo[$fahrer]['zahl']=$hinfo[$fahrer]['zahl']+1; $hinfo[$fahrer]['name']=$row_fahrerx['name']; $hinfo[$fahrer]['last']=$trow['tag'].".".$trow['monat'].".".$trow['jahr']; $key++; } } //echo "

"; print_r($hinfo); echo "

"; //------------------------------------------------------------------------------------------- //------------------------------------------------------------------------------------------- //------------------------------------------------------------------------------------------- //------------------------------------------------------------------------------------------- //------------------------------------------------------------------------------------------- //------------------------------------------------------------------------------------------- //------------------------------------------------------------------------------------------- //------------------------------------------------------------------------------------------- //------------------------------------------------------------------------------------------- //------------------------------------------------------------------------------------------- $template->assign('hinfo', $hinfo); $template->assign('content', 'tpl/phistory.tpl'); ?>