Extension
[query
list=1
st=db
sql=|
SELECT * FROM orderline
WHERE order_number = '[scratch arg]'
ORDER BY code
|
][sql-param quantity] [sql-param sku] [description [sql-param sku]]
[if-sql-data orderline size]SIZE-->[sql-param size][/if-sql-data][if-sql-data orderline color] COLOR-->[sql-param color][/if-sql-data]
[currency][sql-param price][/currency]
[currency][sql-param subtotal][/currency]
[/query]
SUBTOTAL
[currency][loop-data transactions subtotal][/currency]
SALES TAX
[currency][loop-data transactions salestax][/currency]
SHIPPING
[currency][loop-data transactions shipping][/currency][if-loop-data transactions handling]
HANDLING
[currency][loop-data transactions handling][/currency][/if-loop-data]
ORDER TOTAL
[currency][loop-data transactions total_cost][/currency]
[/html-table]