Random Query

[eluser]WhitecastlePT[/eluser]
Hello, here's an example with active records: Works like a charm

Code:

function getAllFotos()
    {
       $data = array();
       $this->db->select();
       $this->db->from('foto_tbl');  
       $this->db->where('isthumb',1);     /* <-- You can remove this */          
       $query = $this->db->get();            
       if($query->num_rows() > 0)
           {
               foreach ($query->result() as $row)
                {
                    $data[] = $row;                    
                }
                srand((float)microtime()*1000000); /* example from suffle function in PHP manual, values can be altered!*/
                shuffle($data);
                return $data;
           }
    }