Welcome Guest, Not a member yet? Register   Sign In
Get Images of an Article
#2

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.
Reply


Messages In This Thread
Get Images of an Article - by demyr - 09-16-2018, 06:07 AM
RE: Get Images of an Article - by jreklund - 09-16-2018, 09:46 AM
RE: Get Images of an Article - by demyr - 09-16-2018, 10:45 PM
RE: Get Images of an Article - by php_rocs - 09-17-2018, 07:49 AM
RE: Get Images of an Article - by Wouter60 - 09-17-2018, 08:42 AM
RE: Get Images of an Article - by demyr - 09-27-2018, 12:47 AM
RE: Get Images of an Article - by Pertti - 09-27-2018, 01:15 AM



Theme © iAndrew 2016 - Forum software by © MyBB