Рейтинг клубам

 
public function setClubRating($club_id){
 
           $rating = 0;
           //рейтинг блога клуба
           $sql = "SELECT SUM(rating) as rating
                   FROM `cms_blogs` 
                   WHERE owner = 'club' AND user_id = '{$club_id}'";
           $rs = $this->inDB->query($sql);
           if ($this->inDB->num_rows($rs)){
	      $data   = $this->inDB->fetch_assoc($rs);
              $rating = $data['rating'] * 5;
           }
           //рейтинг всех фотографий клуба
           $sql = "SELECT SUM(rating) as rating
                   FROM `cms_photo_files` 
                   WHERE owner = 'club{$club_id}'";
           $rs = $this->inDB->query($sql);
           if ($this->inDB->num_rows($rs)){
	      $data   = $this->inDB->fetch_assoc($rs);
              $rating += $data['rating'] * 5;//суммируем
           }
 
           return $this->inDB->query("UPDATE cms_clubs SET rating = $rating WHERE id = '$club_id'");
 
       }