query big problem

[eluser]polish[/eluser]
I have the solution. Maybe it isn't optiumum but he is working ok! I created a new view com_news who listing Me the only one news and the view com_loop who loop Me all comments for this news!

This is the working controller function:

Code:

function show()
    {
    $this->load->model('Comments');
    $this->load->model('News');
    $news_id = $this->uri->segment(3);
    IF(isset($news_id) and is_numeric($news_id))
        {
        $query = $this->News->news_for_com($news_id);
        $query1 = $this->Comments->get_comments_for_news($news_id);
        $content = '';
        if ($query->num_rows() == 1)
            {
            foreach($query->result() as $item)
                    {
                    $content .= $this->load->view('com/com_news', $item, True);
                    }
            }
        if ($query1->num_rows() > 0)
            {
            foreach($query1->result() as $item)
                    {
                    $content .= $this->load->view('com/com_loop', $item, True);
                    }
            }
        else
            {
                $content = '<h1><center>No Comments</center></h1>';
            }
        }
    else
        {
        $this->response['content'] = '<h1><center>Bad Link</center></h1>';
        }
        $this->response['content'] = $content;
    $this->load->view('index', $this->response);
    }

The topic is SOLVED!!!