[comment] ui_template: Yes ui_template_name: leftonly [/comment] [tmp members_only]1[/tmp] [tmp page_title]__COMPANY__ -- [L]Order History[/L][/tmp] [control reset=1] [control-set] [component]search_box_small[/component] [/control-set] [control-set] [component]product_tree[/component] [/control-set] [control-set] [component]cart_tiny[/component] [/control-set] [control reset=1] @_LEFTONLY_TOP_@
[warnings auto=1]

Date | Order ID | Qty Total | Payment Method | Subtotal | Shipping/Handling | TOTAL | Status
[query list=1 sql="select * from transactions where username = '[data session username]' order by order_date"]

[convert-date fmt="%B %e, %Y %H:%M"][sql-param order_date][/convert-date]

[sql-param order_number]

[sql-param nitems]

[sql-param payment_method]

[currency][sql-param subtotal][/currency]

[sql-param shipping] [if-sql-param handling > 0]
(handling [sql-param handling]) [/if-sql-param]

[currency][sql-param total_cost][/currency]

[display table=transactions type=display col=status key="[sql-code]"]

[/query]

@_LEFTONLY_BOTTOM_@