Thread

function get_random_entry()
{
    // SELECT column FROM table ORDER BY RAND() LIMIT 1            
    $query = $this->db->select('artist,title,location')->from('songs')->orderby(RAND())->limit(1);
    foreach ($query->result() as $row) // <- LINE 25
    {
        echo $row->artist;
        echo $row->title;
        echo $row->location;
    }
}

$query = $this->db->select('artist,title,location')->from('songs')->orderby('RAND()')->limit(1);

$this->db->select('artist,title,location')->from('songs')->orderby('RAND()')->limit(1);

            $query = $this->db->get(); // the magic line :D

            foreach ($query->result() as $row)
        {
            echo $row->artist;
            echo $row->title;
            echo $row->location;
        }