/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 vote218 views1 answer
Update Query in Codeigniter Using Multiple Where Condition
PHP CodeIgniter
0 vote299 views1 answer
Codeigniter abort 404
PHP CodeIgniter
0 vote220 views1 answer
Codeigniter select where
PHP CodeIgniter
0 vote234 views1 answer
Where condition in array in codeigniter
PHP CodeIgniter
0 vote237 views5 answers
Codeigniter.com cart
PHP CodeIgniter
0 vote222 views1 answer
Codeigniter how to know update failed
PHP CodeIgniter
0 vote266 views1 answer
Upload image with watermark in codeigniter
PHP CodeIgniter
0 vote335 views1 answer
Codeigniter form validation datetime
PHP CodeIgniter
0 vote229 views3 answers
Upload multiple files in codeigniter
PHP CodeIgniter
2 votes236 views2 answers
Last insert id model codeigniter
PHP CodeIgniter