Login

06-15-2010, 12:02 AM

[eluser]Timothy_[/eluser]
Hello,

This is a situation I have found myself in a few times and I just want clear it up once and for all.

Best just to show you what I need to do in some example code.

My Controller

Code:
function my_controller()

{

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

$this->db->from('cue_sheets');

$this->db->where('id', $id);

$data['get_cue_sheets'] = $this->db->get();

$this->db->from('clips');

$this->db->where('sheet_id', ' CUE SHEET ID GOES IN HERE ??? ');

$data['get_clips'] = $this->db->get();

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

}

My View

Code:
&lt;?php if($get_cue_sheets->result_array()) { ?&gt;

    &lt;?php foreach($get_cue_sheets->result_array() as $sheetRow): ?&gt;

        <h1>&lt;?php echo $sheetRow['sheet_name']; ?&gt;</h1>

        <br/>

        &lt;?php if($get_clips->result_array()) { ?&gt;

            <ul>

                &lt;?php foreach($get_clips->result_array() as $clipRow): ?&gt;

                    <li>&lt;?php echo $clipRow['clip_name']; ?&gt;</li>

                &lt;?php endforeach; ?&gt;

            </ul>

        &lt;?php } else { echo 'No Clips Found'; } ?&gt;

    &lt;?php endforeach; ?&gt;

&lt;?php } ?&gt;

So basically I am trying to display a number of sheets and then within each of those sheets the clips that belong to that sheet.

I hope this makes sense to someone out there.

Thanks,

Tim