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. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.