select distinct genre from dvd where format <> 'MERC' order by genre select distinct collection from dvd where featured = 4 and format <> 'MERC' order by collection select count(username) As TotalRecords from users where username = '#client.username#' and logged = 1 Cart - Rareflix.com
UserName could not be found!!
If incorrect please try and log-in or create a new account.
UserName:
Password:
UserName:
Password:
insert into cart (username, upc, quantity, price, extended, cart_type) values ('#client.username#', 'STANDARD', 1, 19.95, 19.95, 'S') insert into cart (username, upc, quantity, price, extended, cart_type) values ('#client.username#', 'PLUS', 1, 23.99, 23.99, 'S') insert into cart (username, upc, quantity, price, extended, cart_type) values ('#client.username#', 'PRO', 1, 28.99, 28.99, 'S') insert into cart (username, upc, quantity, price, extended, cart_type) values ('#client.username#', 'PREMIUM', 1, 32.99, 32.99, 'S') insert into cart (username, upc, quantity, price, extended, cart_type) values ('#client.username#', 'PLATINUM', 1, 37.99, 37.99, 'S') select cart.*, dvd.synopsis, dvd.title from cart, dvd where ((cart.upc = dvd.upc) and (cart.username = '#client.username#')) select count(username) As TotalRecords from cart where username = '#client.username#' select sum(extended) As TotalInvoice from cart where username = '#client.username#'
Your shopping cart is empty!!
Remove#title#
#NumberFormat(get_cart_total.TotalInvoice, '999,999.00')# readonly>