tomato Posted May 10, 2006 Share Posted May 10, 2006 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 and are named differently ".TABLE_PREFIX."p827_shop_product".TABLE_PREFIX."p827_shop_cartI'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. Link to comment Share on other sites More sharing options...
fenway Posted May 10, 2006 Share Posted May 10, 2006 No need to [a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=93235&st=0&gopid=373090entry373090\" target=\"_blank\"]double-post[/a]; an edit would have sufficed. Link to comment Share on other sites More sharing options...
tomato Posted May 10, 2006 Author Share Posted May 10, 2006 [!--quoteo(post=373091:date=May 10 2006, 03:51 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ May 10 2006, 03:51 PM) [snapback]373091[/snapback][/div][div class=\'quotemain\'][!--quotec--]No need to [a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=93235&st=0&gopid=373090entry373090\" target=\"_blank\"]double-post[/a]; an edit would have sufficed.[/quote]Sorry fenway, It was a quick double click, hit stop to add the whole function in the post manuver. I wasn't trying to be a pest ;)[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] Link to comment Share on other sites More sharing options...
Recommended Posts