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

0 vote259 views1 answer
Mysql between all months days even null
PHP
0 vote257 views1 answer
How to find the name of login user in laravel
PHP
1 vote265 views1 answer
Model json laravel accessor to convert to array
PHP
2 votes312 views2 answers
Php strftime datetime
PHP
0 vote274 views1 answer
Get_template_part parameters
PHP
0 vote317 views1 answer
Laravel check model column was changed
PHP Laravel
2 votes249 views1 answer
Laravel check if session variable exists
PHP
11 votes253 views4 answers
Number format php
PHP
1 vote313 views1 answer
Laravel change post request before save
PHP Laravel
0 vote239 views1 answer
The requested php extension ext-intl * is missing from your system ubuntu
PHP