Get Images of an Article

You never specified the table "products" in your join.

PHP Code:

$this->db->join('gallery', 'gallery.imageproductid=products.productid' ); 


But if you have multiple images I would make a separate SQL query instead. Or you need to ignore the duplicated data.