display db data from to tables on one page

[eluser]matches[/eluser]
Hello,

I am trying to load data from two tables one is being loaded in index function like so:

Code:

function index()
{
    $id = $_GET['id'];
        
    $sql = "SELECT * FROM entries WHERE id = $id";
    $data['query'] = $this->db->query($sql);        
    $this->load->view('permalink/index', $data);        
}

This gives me an error. I am guessing because of of the $this

error:

Fatal error: Using $this when not in object context in C:\xampp\htdocs\IanSeabock\system\application\controllers\permalink.php on line 35

Code:

function showComments($blogId)
{
    $sql = "SELECT * FROM comments WHERE blogId = $blogId";
    $data['query'] = $this->db->query($sql);        
    $this->load->view('permalink/index', $data2);
            
    foreach($query->result() as $commentRow):
    echo '<div class="blogEntry">';
    echo '    <h2>' . $commentRow->author . '</h2>';
    echo '    <h3>' . $commentRow->comment . '</h3>';
    echo '</div>';
    endforeach;
                            
}

Thanks for any help