[eluser]Référencement Google[/eluser]
Whoooops... just got it !
If it can help somebody:
Code:
function list_all($lang, $limit = FALSE, $offset = FALSE)
{
$this->db->select('*');
$this->db->select("DATE_FORMAT(datetime, '%d.%m.%Y à %H:%i:%s') AS datetime");
$this->db->where('lang', $lang);
$this->db->limit($limit);
$this->db->offset($offset);
$this->db->order_by('datetime', 'desc');
$query = $this->db->get('news');
return $query->result();
}