37 lines
No EOL
1.1 KiB
PHP
37 lines
No EOL
1.1 KiB
PHP
<?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');
|
|
|
|
?>
|