assign("currentTitle", "Standorte"); $sQ = $db->assoc($db->query("SELECT * FROM firma WHERE `id`=".$_SESSION['login']['firma'])); $smarty->assign("firma", $sQ); $fu = $db->query("SELECT * FROM route WHERE `datum`>".strtotime(date("d.m.Y")." 00:00:00")." AND `datum`<".strtotime("+2 days")." AND `userid`=".$_SESSION['login']['id']); while($sQ = $db->assoc($fu)) { $r[] = $sQ; } $smarty->assign("route", $r); $smarty->assign("currentPage", $smarty->fetch("locations.tpl")); include("includes/footer.php"); ?>