SELECT * FROM CartItems WHERE CartIDReference = #Cookie.cartCookie# ORDER BY CartItemID delete from cartitems where CartIDReference = #Cookie.cartCookie# and cartitemid=#cartitemid# update cartitems set quantity=#quantity#, totalPrice=#quantity#*lockPrice where CartIDReference = #Cookie.cartCookie# and cartitemid=#cartitemid# delete from cartitems where CartIDReference = #Cookie.cartCookie# and cartitemid=#cartitemid#