<?php
$tankxx = $GLOBALS['mysql']->query("SELECT * FROM tanken WHERE open=1 ORDER BY diesel ASC LIMIT 3"); $key=0;
while($tank = $tankxx->fetch_assoc()) {

	$tankex[$key]['open']=$tank['open'];
	$tankex[$key]['kname']=$tank['kname'];
	$tankex[$key]['adr1']=$tank['name'];
	$tankex[$key]['adr2']=$tank['street'];
	$tankex[$key]['adr3']=$tank['plz'];
	$tankex[$key]['adr4']=$tank['ort'];
	$tankex[$key]['diesel']=substr($tank['diesel'], 0, -1);
	$tankex[$key]['dieselx']=substr($tank['diesel'], -1, 1);
	$key++;
}

$tanktx = $GLOBALS['mysql']->query("SELECT * FROM tanken WHERE open=1 ORDER BY diesel DESC LIMIT 3"); $key=0;
while($tankxx = $tanktx->fetch_assoc()) {

	$tankt[$key]['open']=$tankxx['open'];
	$tankt[$key]['kname']=$tankxx['kname'];
	$tankt[$key]['adr1']=$tankxx['name'];
	$tankt[$key]['adr2']=$tankxx['street'];
	$tankt[$key]['adr3']=$tankxx['plz'];
	$tankt[$key]['adr4']=$tankxx['ort'];
	$tankt[$key]['diesel']=substr($tankxx['diesel'], 0, -1);
	$tankt[$key]['dieselx']=substr($tankxx['diesel'], -1, 1);
	$key++;
}


$template->assign('tanke', $tankex);
$template->assign('tanket', $tankt);
$template->assign('content', 'tpl/ajax/tankebillig.tpl');

?>