how to included a file with in controller

[eluser]sheolikar[/eluser]
sir ,

answer i got from yesterday is not one i m expecting.may be i could not explain in
better way.i will try again.what i mean is that.

consider database query is there inside header or footer.and in controller page
we are using it as in this way.

$this->load->vars($data);
$this->load->view('header');
$this->load->view('contentleft');
$this->load->view('home');
$this->load->view('footer');

now there is no header.php or footer.php in controller.it display result in onlyone
i.e if in home page we are declared above code.it shows database results inhomepage
only.in other pages like client details where to we are using header and footer.it
display error.

so i tried to create header.php in controller side and written sql query there.
but when i tried to include that header.php .it gives error.
any solution.