Question : codeigniter order by random
Answered by : mukul-hosen
function get_random_page()
{ $this->db->order_by('id', 'RANDOM'); or $this->db->order_by('rand()'); $this->db->limit(1); $query = $this->db->get('pages'); return $query->result_array();
}Source : https://stackoverflow.com/questions/1627934/random-record-from-mysql-database-with-codeigniter | Last Update : Fri, 26 Nov 21