<?php

error_reporting(E_ALL); ini_set('display_errors',1);

$kw_alt = date('W',time()-604800);
$jahr_alt = date('Y',time()-604800);
$key=0;
$lastweek = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE kw='".$kw_alt."' and jahr='".$jahr_alt."' and typ=8");
while($row = $lastweek->fetch_assoc()) {
	$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
	$lw[$key]['tour']=$row_tour['tour'];
	$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
	$lw[$key]['fahrer']=$row_fahrerx['name'];
	$row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
	$lw[$key]['kennz']=$row_autox['kz'];
	$key++;

}
$template->assign('lw', $lw);
$template->assign('content', 'tpl/ajax/last_week_8.tpl');
?>