query("SELECT * FROM fahrzeuge WHERE aktiv>0 and besitz<3 and sanidate>1 ORDER BY kz"); while($row = $tempcar2->fetch_assoc()) { $temptime=time(); $temptime=$temptime+2678400; if($row['sanidate']<=time()) { $anzeige=1; $sanidata[$key]['typ']=1; $sanidata[$key]['kz']=$row['kz']; $sanidata[$key]['sanidate']=$row['sanidate']; $key++; } elseif($row['sanidate']<=$temptime) { $anzeige=1; $sanidata[$key]['typ']=2; $sanidata[$key]['kz']=$row['kz']; $sanidata[$key]['sanidate']=$row['sanidate']; $key++; } } $template->assign('anzeige', $anzeige); $template->assign('sanidata', $sanidata); $template->assign('content', 'tpl/ajax/sani.tpl'); ?>