Get Images of an Article

Hello there,

I'm new to Codeigniter and to this forum as well.

I'm trying to publish my articles (products). On any product page there will be a gallery showing the related images about the product. I've tried the JOIN method below upon a tutorial, however I cannot fetch all the photos. How can I get all the images and show them like a photo gallery?

My Gallery table has a "imageproductid" column on which I make the join for "product"

My DB :

PHP Code:

function singleproduct($a)
    {
        $this->db->select('*');
        $this->db->from('products');
        $this->db->where('productslug', $a);
    
        $this->db->join('gallery', 'gallery.imageproductid=productid' );
        $myresult=$this->db->get()->row();
        return $myresult;
    } 


My Controller:

PHP Code:

public function products($link)
    {
        $this->load->model('mydb');
        $result = $this->mydb->singleproduct($link);
        $data['information']=$result;

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


My View:
 

Code:

<img src="<?php echo base_url($information->imagepath);?>" class="max"/>