[Nemanja Inc]

Imam dvije tabele (slike i kategorije) koje izgledaju ovako:

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `images` (
  `id` int(11) NOT NULL,
  `categories_id` int(11) NOT NULL,
  `file` text NOT NULL,
  `caption` text NOT NULL,
  `description` text NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Imam cetri kategorije i potrebna mi je ideja kako da dinamicki filtriram slike po uslovu kojoj kategoriji pripadaju.

**Model:**
public function org_filter()//filter categories
    {
        $this->db->select('i.file,i.categories_id,c.id,c.title',false);
        $this->db->from('images as i');
        $this->db->join('categories as c','i.categories_id = c.id','inner');//join tables based on the foreign key
        $this->db->where('c.title','organizers');//set filter 
        $query = $this->db->get();//get data*/
        return $query;
    }

 **Controller**
 $data=array(
    'r_images'   => $this->Gallery_model->org_filter(),
 );

         $this->load->view('layouts/main', $data);

  **View**
     <h3 class="svgbg">ORGANIZERS</h3><!--name of the first category-->
    <?php foreach($r_images->result() as $img) : ?>
        <div>
            <div class="thumbnail">
                <?=img($img->file)?>
            </div>
        </div>
    <?php endforeach; ?>