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

6 votes265 views2 answers
Get value from input field in php
PHP
2 votes252 views3 answers
Php reverse string
PHP
0 vote246 views1 answer
Php check if checkbox isset
PHP
5 votes236 views2 answers
Laravel auth namespace
PHP
0 vote339 views1 answer
Wordpress post types supports thumbnail
PHP Wordpress
11 votes296 views2 answers
Wp-config override site url
PHP
8 votes256 views3 answers
Cakephp 2 with customize link
PHP
0 vote261 views1 answer
Laravel datatable columnDefs
PHP Laravel
1 vote230 views1 answer
Laravel roles
PHP
0 vote250 views1 answer
Downgrade php version vagrant
PHP