/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

1 vote331 views1 answer
Codeigniter distinct
PHP CodeIgniter
0 vote335 views1 answer
Access config variable in codeigniter controller
PHP CodeIgniter
2 votes307 views1 answer
Codeigniter row count returns 1 always
PHP CodeIgniter
1 vote340 views2 answers
Print all session in codeigniter
PHP CodeIgniter
0 vote351 views1 answer
How to free session variable in php codeigniter
PHP CodeIgniter
0 vote321 views1 answer
Encryp with codeigniter 3
PHP CodeIgniter
2 votes352 views2 answers
Last insert id model codeigniter
PHP CodeIgniter
0 vote335 views1 answer
Codeigniter select where
PHP CodeIgniter
0 vote355 views2 answers
Load session in codeigniter
PHP CodeIgniter
0 vote313 views1 answer
Destroy session codeigniter 3
PHP CodeIgniter