<?php

function getorder($orderid){
	sqlconnect();
	$results=mysql_query("SELECT orderid, vendorid, opened, vat FROM orders WHERE orderid like '".mysql_real_escape_string($orderid)."'");
	while($row=mysql_fetch_assoc($results)){
			$row['vendor']=vendorLookup($row['vendorid']);
			$orders[]=$row;
	}
	$results=mysql_query("SELECT * FROM order_data where orderid like '".mysql_real_escape_string($orderid)."'");
	while($row=mysql_fetch_assoc($results)){
			$row['prodname']=prodname($row['prodid']);
			$row['vat']=round($row['price']*(1+($orders['vat']/100)),2);
			$row['linetotal']=round($row['price']*$row['qnty'],2);
			$order_items[]=$row;
	}
	$return[0]=$order_items;
	$return[1]=$orders;
	return $return;
}
?>