HOW TO INSERT QUERY IN PRODUCT COMPARISON TPL

[spemar]

I need to insert a 2nd image in product comparison page .

The mysql query is:

SELECT id_image FROM ps3image WHERE id_product = X AND position = 2

 

How can I insert in products-comparison.tpl ??

 

Thanx

 

Marco

[be_tnt]

Hello!

 

The tpl is not a place for SQL query.

What you can do is to override the product controller and add this information in a smarty variable.

[spemar]

Can you please do an example?

[spemar]

I've add this line code in ProductController:

 

 

public function imagePos2()

 

{

$result = Db::getInstance()->executeS('

SELECT `id_image`

FROM `'._DB_PREFIX_.'image`

WHERE `id_product` = '.(int)$id_product.'

AND position = 2');

$smarty>assign('ImEtich', $result);

}

 

How to get image in product-comparison.tpl?

[be_tnt]

I guess imagePos2 is called by the hook function, right? In that case, ImEtich variable is accessible for the tpl.

Edited January 27, 2013 by be_tnt (see edit history)