Code: Select all
$query = "SELECT * FROM `rating` WHERE `id`='$db_id'";
$result = mysql_query($query);
$totalrows = mysql_num_rows($result);
if ($totalrows == 0) {
$stars = '<span>Not Rated</span>';
} else {
$rate = mysql_fetch_array($result);
$rating_value = array_sum($rate['rating_value']);
$rating = round($rating_value/$totalrows,1);
if ($rating <= 1.4) {
$stars = '<img src="images/star.gif">';
} elseif ($rating <= 2.4) {
$stars = '<img src="images/star.gif"><img src="images/star.gif">';
} elseif ($rating <= 3.4) {
$stars = '<img src="images/star.gif"><img src="images/star.gif"><img src="images/star.gif">';
} elseif ($rating <= 4.4) {
$stars = '<img src="images/star.gif"><img src="images/star.gif"><img src="images/star.gif"><img src="images/star.gif">';
} else {
$stars = '<img src="images/star.gif"><img src="images/star.gif"><img src="images/star.gif"><img src="images/star.gif"><img src="images/star.gif"><img src="images/star.gif"><img src="images/star.gif"><img src="images/star.gif"><img src="images/star.gif"><img src="images/star.gif">';
}
}