/PHP/CodeIgniter/Codeigniter order by random

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 vote436 views2 answers
Multiple image upload with CodeIgniter
PHP CodeIgniter
0 vote331 views1 answer
Time zone set in codeigniter
PHP CodeIgniter
0 vote344 views1 answer
Insert array values in database using codeigniter
PHP CodeIgniter
3 votes381 views1 answer
Codeigniter form_validation email
PHP CodeIgniter
0 vote369 views1 answer
Php artisan spark not working in codeigniter
PHP CodeIgniter
0 vote348 views1 answer
Confirm password in codeigniter
PHP CodeIgniter
0 vote363 views1 answer
Codeigniter set db prefix
PHP CodeIgniter
0 vote373 views1 answer
Update query in codeigniter using where condition
PHP CodeIgniter
3 votes411 views3 answers
$this- db- where in codeigniter
PHP CodeIgniter
0 vote316 views1 answer
Imagelib thourgh class in codeigniter
PHP CodeIgniter