Login

12-15-2007, 12:29 PM

[eluser]JimmyJ[/eluser]
Hi, i'm trying to pass an id variable to an sql query, but gives me the error:

Error Number: 1054

Unknown column '$id' in 'where clause'

SELECT * FROM pages WHERE pageID=$id

The code is:

Code:
&lt;?php

class Page extends Controller {

    function Page()

    {

        parent::Controller();    

    }

    function view()

    {

    /* Get Template */

    $data['doctypes'] = $this->load->view('template/doctypes', '', true);

    $data['head'] = $this->load->view('template/head', '', true);

    $data['foot'] = $this->load->view('template/foot', '', true);

    /* Get DB Content */

    $id = $this->uri->segment(2);

    $query = $this->db->query('SELECT * FROM pages WHERE pageID=$id');

    $row = $query->row();  

    $data['metaTitle'] = $row->metaTitle;

    $data['pageTitle'] = $row->pageTitle;

    $this->load->view('page', $data);

    }

}

?&gt;

What am I doing wrong? I've looked through the database documentation but the examples are a little limited. It works fine in my head Sad

Any ideas?