public function getImageByGalleryId($id, $pagination = NULL) { $sql = 'SELECT SQL_CALC_FOUND_ROWS g.image_id,g.cat,g.id as imgid,g.image_title,g.image_description,g.visits, m.url, m.id, m.url_thumb FROM `[prefix]_gallery_imgs` AS g LEFT JOIN `[prefix]_media` m ON g.image_id = m.id WHERE g.cat = ' . $id . ' ORDER BY g.id DESC LIMIT ' . implode(',', $pagination->getLimit()); $imageArray = $this->db()->queryArray($sql); $pagination->setRows($this->db()->querycell('SELECT FOUND_ROWS()')); $entry = array(); foreach ($imageArray as $entries) { $entryModel = new ImageModel(); $entryModel->setImageUrl($entries['url']); $entryModel->setImageThumb($entries['url_thumb']); $entryModel->setId($entries['imgid']); $entryModel->setImageTitle($entries['image_title']); $entryModel->setImageDesc($entries['image_description']); $entryModel->setVisits($entries['visits']); $entryModel->setCat($entries['cat']); $entry[] = $entryModel; } return $entry; }