'); $DbResult = $Database->query("SELECT * FROM network_segments"); while($Row = $DbResult->fetch_array()) { echo(''); $DbResult2 = $Database->query("SELECT * FROM network_devices WHERE segment=".$Row['id']." AND used=1"); while($Row = $DbResult2->fetch_array()) { echo(''); } } $DbResult = $Database->query("SELECT SUM(price) FROM network_devices WHERE used=1"); $Row = $DbResult->fetch_array(); echo(''); echo('

Název	Spotřeba [W]	Datum zakoupení	Cena [Kč]
Segment: '.$Row['name'].' ('.$Row['users'].')			'.$Row['price'].'
'.$Row['name'].'	'.$Row['consumption'].'	'.HumanDate($Row['date']).'	'.$Row['price'].'
Celkem:			'.$Row[0].'

'); ShowFooter(); ?>