select('transactions', ['txid', 'txdate', 'type'], ['customerid' => $account['id'], 'ORDER' => ['txdate' => 'DESC'], 'LIMIT' => 50]);
foreach ($orders as $o) {
$lines = $database->select('lines', ['lineid', 'amount', 'qty', 'name'], ['txid' => $o['txid']]);
$itemcount = 0;
$total = 0.0;
foreach ($lines as $l) {
$itemcount += $l['qty'];
$total += $l['amount'] * $l['qty'];
}
?>