$result = mysql_query('SELECT sum(product.itemprice * cart.quantity) as price FROM ".TABLE_PREFIX."p827_shop_product product, ".TABLE_PREFIX."p827_shop_cart cart WHERE cart.session=\''.$this->get_sess().'\' AND product.pid = cart.pid');
My table names have a prefix and are named differently
I've been messing with this for hours would one of you re-write the query or point me to my failure please.
This is beyond my understanding.
Thanks for looking guys.