<?php
$_SESSION['m1']=0; $_SESSION['m2']=0;
error_reporting(E_ALL); ini_set('display_errors',1); 

$abfrage = $GLOBALS['mysql']->query("SELECT * FROM tanken ORDER BY diesel"); $key=0;
while($row = $abfrage->fetch_assoc()) {
	$tankdata[$key]['e5']=substr($row['e5'], 0, -1);
	$tankdata[$key]['e5x']=substr($row['e5'], -1, 1);
	$tankdata[$key]['e10']=substr($row['e10'], 0, -1);
	$tankdata[$key]['e10x']=substr($row['e10'], -1, 1);
	$tankdata[$key]['diesel']=substr($row['diesel'], 0, -1);
	$tankdata[$key]['dieselx']=substr($row['diesel'], -1, 1);
	$tankdata[$key]['name']=$row['name'];
	$tankdata[$key]['open']=$row['open'];
	$tankdata[$key]['kname']=$row['kname'];
	$tankdata[$key]['street']=$row['street'];
	$tankdata[$key]['ort']=$row['ort'];
	$tankdata[$key]['hnr']=$row['hnr'];
	$tankdata[$key]['plz']=$row['plz'];
	$key++;
}

$abfrage2 = $GLOBALS['mysql']->query("SELECT * FROM tanken WHERE anzid>0 ORDER BY diesel"); $key=0;
while($row = $abfrage2->fetch_assoc()) {
	$tankdata2[$key]['e5']=substr($row['e5'], 0, -1);
	$tankdata2[$key]['e5x']=substr($row['e5'], -1, 1);
	$tankdata2[$key]['e10']=substr($row['e10'], 0, -1);
	$tankdata2[$key]['e10x']=substr($row['e10'], -1, 1);
	$tankdata2[$key]['diesel']=substr($row['diesel'], 0, -1);
	$tankdata2[$key]['dieselx']=substr($row['diesel'], -1, 1);
	$tankdata2[$key]['name']=$row['name'];
	$tankdata2[$key]['open']=$row['open'];
	$tankdata2[$key]['kname']=$row['kname'];
	$tankdata2[$key]['street']=$row['street'];
	$tankdata2[$key]['ort']=$row['ort'];
	$tankdata2[$key]['hnr']=$row['hnr'];
	$tankdata2[$key]['plz']=$row['plz'];
	$key++;
}


$template->assign('tankdata',$tankdata);	
$template->assign('tankdata2',$tankdata2);	
$template->assign('content', 'tpl/tankstellen.tpl');
?>