/** * Get an array with minimalistic attachment meta data * * @param integer $start Listing start * @param integer $limit Listing end * * @return array */ public function getBreadcrumbs($start = 0, $limit = 0) { $retval = array(); $query = sprintf("\n SELECT\n fa.id,\n fa.record_id,\n fa.record_lang,\n fa.filename,\n fa.filesize,\n fa.mime_type,\n fd.thema\n FROM\n %s fa\n JOIN\n %s fd\n ON\n fa.record_id = fd.id", SQLPREFIX . 'faqattachment', SQLPREFIX . 'faqdata'); $result = $this->db->query($query); if ($result) { $retval = $this->db->fetchAll($result); } return $retval; }
/** * Get an array with minimalistic attachment meta data * * @param integer $start Listing start * @param integer $limit Listing end * * @return array */ public function getBreadcrumbs($start = 0, $limit = 0) { $retval = array(); $sql = str_replace(array('_t1_', '_t2_'), array(SQLPREFIX . "faqattachment", SQLPREFIX . "faqdata"), "SELECT\n\t\t\t _t1_.id,\n _t1_.record_id, _t1_.record_lang,\n _t1_.filename, _t1_.filesize, _t1_.mime_type,\n _t2_.thema\n FROM\n _t1_\n JOIN _t2_ ON _t1_.record_id = _t2_.id"); $result = $this->db->query($sql); if ($result) { $retval = $this->db->fetchAll($result); } return $retval; }