mambax7 / xoops-martin

        $sql .= "$where     order BY h.hotel_rank ,h.hotel_id DESC ";

        $query    = $this->db->query($sql, $limit, $start);

        $cityList = &self::getCityList();

        while ($row = $this->db->fetchArray($query)) {

            $city_ids = explode(',', $row['hotel_city_id']);

            foreach ($city_ids as $id) {

                $city_name[] = $cityList[$id];

            }

            $hotel_ids[]            = $row['hotel_id'];

            $row['city_name']       = implode('、', $city_name);

            $row['hotel_open_time'] = date('Y-m-d H:i:s', $row['hotel_open_time']);

            $row['hotel_add_time']  = date('Y-m-d H:i:s', $row['hotel_add_time']);

            $nrows[]                = $row;

            unset($row, $city_name);

        }

        $this->hotel_ids = &$hotel_ids;

        //echo '<pre>';print_r($nrows);

        $result          = $this->db->query($sql);

        $this->hotel_ids = &$hotel_ids;

        $cityList        = &$hotel_handler->getCityList();

        while ($row = $this->db->fetchArray($result)) {

            $hotel_ids[] = $row['hotel_id'];

            $city_ids    = explode(',', $row['hotel_city_id']);

            foreach ($city_ids as $id) {

                $city_name[] = $cityList[$id];

            }

            $row['city_name']    = implode('、', $city_name);

            $row['hotel_image']  = unserialize($row['hotel_image']);

            $row['hotel_google'] = unserialize(unserialize($row['hotel_google']));

            //var_dump($row['hotel_google']);

            $rows[] = $row;

            unset($city_name);

        }

        //$rows = $this->GetRows($sql,'hotel_id');

        return $rows;