Query Restructure

[tomato]

I'm "TRYING" utilizing the following code and can't seem to get a valid resource.

[code]$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');
[/code]

My table names have a prefix.

".TABLE_PREFIX."p827_shop_product
".TABLE_PREFIX."p827_shop_cart

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.

Here's the whole function

Thanks for looking guys.[code]function total()
{
   global $DB;//         Price from the product table and the quntity from the carts table
$query ="SELECT sum(".TABLE_PREFIX."p827_shop_product.itemprice * ".TABLE_PREFIX."p827_shop_cart.quantity) as price FROM ".TABLE_PREFIX."p827_shop_product, ".TABLE_PREFIX."p827_shop_cart WHERE ".TABLE_PREFIX."p827_shop_cart.session=\''.$this->get_sess().'\' AND ".TABLE_PREFIX."p827_shop_product.pid = ".TABLE_PREFIX."p827_shop_cart.pid";

$result = mysql_query($query);
$row = mysql_fetch_array($result);
return $row['price'];
}[/code]

[fenway]

Not sure why you're escaping your single quotes, or why you don't have a concat operator after your '/'.

[tomato]

[!--quoteo(post=373090:date=May 10 2006, 03:50 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ May 10 2006, 03:50 PM) [snapback]373090[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Not sure why you're escaping your single quotes, or why you don't have a concat operator after your '/'.
[/quote]


Super Sweet! thank you.