Example #1
0
 public static function getRatingNumToListing($listing_sid)
 {
     $result = SJB_DB::query("SELECT COUNT(*) AS `num` , ROUND((SUM(vote) / COUNT(*)), 1) AS rating FROM `rating` WHERE `listing_id` = ?n ", $listing_sid);
     $row = array_shift($result);
     self::$rating = is_numeric($row['rating']) ? $row['rating'] : 0;
     self::$num = is_numeric($row['num']) ? $row['num'] : 0;
     return self::$num;
 }