Dynamic Causes

causes.php

  $campaigns = array();
  $sql = "SELECT * FROM svn_posts WHERE post_type = 'shirts' AND post_date < now() ORDER BY ID DESC LIMIT 10";  
  $query = $this->db->query($sql);
    
  // create organized arrays of campaign data
  foreach($query->result() as $campaign){
    $sql = 'SELECT * FROM svn_postmeta WHERE post_id = ' . $campaign->ID;
    $results = $this->db->query($sql)->result();
    $meta = array();

    // loop through meta results and organize them
    foreach($results as $result){
      $meta[$result->meta_key] = $result->meta_value;
    }
      
    // this array holds all the campaign info
    $campaigns[$campaign->ID] = array(
      'campaign'	=> $campaign,
      'meta'			=> $meta
    );
  }
	  
  // this array doesn't work.
  // need to work on the organization of the meta data
  return $campaigns;