Codeigniter order by random

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: stackoverflow.com

Similar codes

4 votes293 views4 answers
Php array to js
PHP
2 votes363 views2 answers
Laravel foreach first
PHP Laravel
8 votes312 views4 answers
Php wait
PHP
0 vote307 views1 answer
Laravel api get controller
PHP Laravel
0 vote554 views1 answer
Php questions in tasks
PHP
2 votes356 views6 answers
Laravel get query parameters
PHP
3 votes298 views2 answers
How to export database from phpmyadmin
PHP
8 votes322 views6 answers
Command not found: laravel
PHP
5 votes313 views1 answer
Php get age from dob
PHP
6 votes335 views4 answers
Laravel blade foreach index value
PHP Laravel