"); //*** MENU SYSTEM NEW STYLE ---------------------------------------------------- include ("/var/www/html/robotigs/mobile/menu.php"); //Mobile menu bar //*** FROM HERE ON THE NORMAL USER SCREEN STARTS ------------------------------- $qry=("SELECT floraseed.sedid , SUBSTRING(ordername FROM 1 FOR POSITION(' ' IN ordername)) , INITCAP(SUBSTRING(ordername, POSITION(' ' IN ordername)+1)) , to_char(CAST(price AS numeric)/100, '9990D99') , price , url FROM floraseed WHERE floraseed.statusid = 2 ORDER BY LPAD (SUBSTRING(ordername FROM 1 FOR POSITION(' ' IN ordername)),7,'0' ) ASC ;"); $result = pg_query($con, $qry); $totaalEUR = 0; //Total amount of the order in EURO $colli = 0; echo (""); while($field = pg_fetch_array($result)){ //Make the fields accessible echo (""); echo (""); echo (""); echo (""); echo (""); $totaalEUR = $totaalEUR + $field[4]; $colli++; } $show = number_format($totaalEUR/100, 2, ',', '.'); //Format temperature reading echo (""); echo (""); echo (""); echo (""); echo (""); echo (""); echo ("

$field[1]	$field[2]		$field[3]
$colli	colli	Totaal €	$show

"); ?>