/**
* This function is used to get the review rating
*
*
* @return string
*/
function reviewRating()
{
$sql = "SELECT a.product_id,sum(c.rating)/count(c.user_id) as\n\t\t\trating FROM products_table as a left join product_reviews_table c on a.product_id=c.product_id where a.product_id=" . (int) $_GET['prodid'] . " AND a.status=1 group by a.product_id";
$query = new Bin_Query();
if ($query->executeQuery($sql)) {
return Display_DProductDetail::reviewRating($query->records[0]['rating']);
}
}
/**
* Function gets the review details from the database
*
*
* @return string
*/
function reviewRating()
{
$sql = "SELECT product_id,rating FROM `product_reviews_table` WHERE product_id=" . (int) $_GET['prodid'];
$query = new Bin_Query();
if ($query->executeQuery($sql)) {
return Display_DProductDetail::reviewRating($query->records);
}
}
