How to add a product thumbails to invoice (invoice_items.php)?

[Al37]

How to add a product thumbails to invoice (\components\com_virtuemart\views\invoice\tmpl\invoice_items.php)?

Please, tell me the code.

[Al37]

Here it is, may be it will help somebody else..

Code Select Expand

                <?php 
                $db = JFactory::getDbo(); 
                $db->setQuery('SELECT m.file_url_thumb FROM #__virtuemart_product_medias pm,#__virtuemart_medias m WHERE (pm.virtuemart_product_id='.$item->virtuemart_product_id.')AND(pm.virtuemart_media_id=m.virtuemart_media_id)'); 
                $res = $db->LoadResult(); 
                echo "<img src=\"$res\">"; 
                ?>