Prices and Rating

$db->setQuery("SELECT REPLACE(REPLACE(C.currency_positive_style,'{symbol}',C.currency_symbol ),'{number}',cast(P.product_price as decimal(19,2))) As pricetext FROM #__virtuemart_product_prices as P LEFT JOIN #__virtuemart_currencies as C on C.virtuemart_currency_id = P.product_currency WHERE P.virtuemart_product_id = '" . $product_id . "' LIMIT 1 "); $price_object = $db->loadObject(); //var_dump($pr->prices); $price = $pr->prices['salesPrice']; //$price = '<div class="PricepriceWithoutTax">Retail: '.$price_object->pricetext.round($pr->prices,2).'</div>'.'<div class="PricesalesPrice">Sale: '.round($pr->prices['salesPrice'],2).'</div>'; // $price = '<span class="price-crossed"><div class="PricepriceWithoutTax PricebasePriceWithTax">Retail: '.'<span class="PricebasePriceWithTax">'.$price_object->pricetext.round($pr->prices,2).'</span>'.'</div></span>'.'<div class="PricesalesPrice">Sale: $'.sprintf("%1.2f",$pr->prices['salesPrice']).'</div>'; if (round($product->prices['priceWithoutTax'],$this->currency->_priceConfig['salesPrice'][1]) != $product->prices['salesPrice']) { echo '<span class="price-crossed" >' . $this->currency->createPriceDiv ('priceWithoutTax', 'COM_VIRTUEMART_PRODUCT_SALESPRICE_WITHOUT_TAX', $product->prices) . "</span>"; } else { echo $this->currency->createPriceDiv ('priceWithoutTax', 'COM_VIRTUEMART_PRODUCT_SALESPRICE_WITHOUT_TAX', $product->prices) . "<br />"; } if (round($product->prices['salesPrice'],$this->currency->_priceConfig['priceWithoutTax'][1]) != $product->prices['priceWithoutTax']) { echo $this->currency->createPriceDiv('salesPrice','COM_VIRTUEMART_PRODUCT_SALESPRICE',$product->prices); } // $price = '<div class="productPrice">'.$price_object->pricetext.', '.round($pr->prices,2).'</div>'; //$price = '<div class="productPrice">'.$price_object->pricetext.'</div>'; }