mambax7 / xoops-martin

        $sql .= $room_date > 0 ? "and room_date = " . strtotime($room_date) . ' ' : " and room_date BETWEEN " . $Today . " AND " . $NextMouth;

        $sql .= " order by room_id , room_date desc ";

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

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

            if ($room_date > 0) {

                return $row;

            }

            $rows[$row['room_date']] = $row;

        }

        return $room_date > 0 ? $rows[0] : $rows;

    }

        $sql .= " order by room_id , room_date desc ";

        $sql .= " limit $start,$limit ";

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

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

            $row['room_date'] = date('Y-m-d', $row['room_date']);

            $rows[]           = $row;

        }

        return $rows;

    }