I found the function getImages that find image ID on certain product ID:
function getImages() {
$query = "SELECT I.*, IF(P.product_name_image=I.image_name,0,1) as sort FROM `#__jshopping_products_images` as I left join `#__jshopping_products` as P on P.product_id=I.product_id
WHERE I.product_id = '" . $this->_db->getEscaped($this->product_id) . "' ORDER BY sort,I.image_id";
$this->_db->setQuery($query);
return $this->_db->loadObjectList();
}
$query = "SELECT I.*, IF(P.product_name_image=I.image_name,0,1) as sort FROM `#__jshopping_products_images` as I left join `#__jshopping_products` as P on P.product_id=I.product_id
WHERE I.product_id = '" . $this->_db->getEscaped($this->product_id) . "' ORDER BY sort,I.image_id";
$this->_db->setQuery($query);
return $this->_db->loadObjectList();
}
However due to the lack of PHP knowledge I can't manage to insert the image name to product query to display it in category view. So any help is much appreciated.
Thank you!
Joomla: 1.7.3
JoomShopping: 3.2.7
PHP: 5.2.1
MySQL: 5.1.37
Website Url: Being in localhost
JoomShopping: 3.2.7
PHP: 5.2.1
MySQL: 5.1.37
Website Url: Being in localhost
Last change: 06.01.2012 09:43