KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I researched over the internet, but could not find anything... I have a mysql db, and records at a table, and I need to get random record from this table at every page load. how can I do that? Is there any func for that? Appreciate! thanks SORTED: link: http://www.derekallard.com/blog/post/ordering-database-results-by-random-in-codeigniter/ $this->db->select('name'); $query = $this->db->get('table'); $shuffled_query = $query->result_array(); shuffle ($shuffled_query); foreach ($shuffled_query as $row) { echo $row['name'] . '<br />'; }
Tags (comma-separated)
Save Edits
Cancel