/** * Get all the entries from the table faqvisits * * @return array */ function getAllData() { $data = array(); $query = sprintf("\n SELECT\n *\n FROM\n %sfaqvisits\n ORDER BY\n visits DESC", SQLPREFIX); $result = $this->db->query($query); while ($row = $this->db->fetchObject($result)) { $data[] = array('id' => $row->id, 'lang' => $row->lang, 'visits' => $row->visits, 'last_visit' => $row->last_visit); } return $data; }