/** * 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); } }