[eluser]chops[/eluser]
i have used this method before and it worked (pretty sure it was the same syntax), basically trying to load two queries in one view, however i get an error like this
Quote:A PHP Error was encountered
Severity: Notice
Message: Undefined variable: newsdata
Filename: controllers/casestudies.php
Line Number: 19
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: query
Filename: controllers/casestudies.php
Line Number: 20
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: newsquery
Filename: controllers/casestudies.php
Line Number: 22
I thought i could load it via vars but i can't see where i'm going wrong
Code:
function index()
{
$data['query'] = $this->db->get('casestudies');
$data['newsquery'] = $this->db->get('news', 3);
$this->load->vars(array(
'data' => $data,
'newsdata' => $newsdata,
'query' => $query,
'newsquery' => $newsquery
));
$this->load->view('casestudies_view');
}
and my view
Code:
<?php $this->load->view('header'); ?>
<h2>Case Studies</h2>
<?php foreach($query->result() as $row): ?>
<h3><?=$row->title ?></h3>
<img >title ?>/thumbs/<?=$row->image ?>.jpg" alt="<?=$row->title ?>" />
<p><?=anchor('casestudies/project/'.$row->id, 'read the article') ?></p>
<?php endforeach; ?>
</div><!-- end content -->
<div id="sidebar">
<h2>Recent News</h2>
<?php foreach($newsquery->result() as $row): ?>
<h3><?=$row->title ?></h3>
<p><?=$row->date ?></p>
<p><? echo word_limiter($row->body, 28) ?><br />
<?=anchor('news/article/'.$row->id, 'read the article') ?></p>
<hr />
<?php endforeach; ?>
</div><!-- End sidebar -->
<?php $this->load->view('footer'); ?>
why doesn't the query load into the view? is my syntax wrong?