Questions: Display all product's images on category view

06.01.2012 09:35
#1
mogsama
Joomshopping forum user no avatar
Name: mogsama
28.07.2011
Posts: 13
Quote
Questions: Display all product's images on category view

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();
}


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

Letzte Ă„nderung: 06.01.2012 09:43
 
Copyrights MAXXmarketing GmbH. All Rights Reserved