Simple Looping Problem

Hi,

I'm running into a little bit of trouble and would appriciate some guidance.

I currently have a list of statuses held in a database table called 'status'. These are 'Open', 'Closed', 'Pending'.

I also have another table of sales which is in a table called 'sales'.

I'm trying to loop around each status and get the relevant sales, but am having a bit of an issue working out how this is done.

Please note the below code does not work  

Controller:

PHP Code:

// this returns all the statuses (open, closed, pending)
$data["status"] = $this->sales_model->get_status();

// now i want to loop around these and get the all the items with the that status_id
foreach($data['status'] as $status){
    $data["sales"] = $this->sales_model->get_all($status['status_id']);
} 


View:

PHP Code:

<?php foreach ($status as $s){ ?>
    <!-- loop around and get each status -->
    <h1>$s['status_title'];</h1>
    
    <!-- now i want to loop around the results and display them for this status -->
    <?php print_r($sales); ?>

<?php }else{ ?>
    <!-- no status found -->
   <p>Sorry no status found</p>
<?php } ?>

Thank you for your time.

MoFish