View Single Post
  #21  
Old 04-19-2017, 01:17 PM
 
PhilJ PhilJ is offline
 

X-Guru
  
Join Date: Nov 2002
Posts: 4,094
 

Default Re: Proper way for query functionality

If all you are looking to do is display manufacturer icons on the manufacturer list page...

In modules/Manufacturers/customer_manufacturers_list.php

Before...
Code:
$smarty->assign('manufacturers', $manufacturers);
Insert...
Code:
if ($manufacturers) { foreach($manufacturers as $key=> $manufacturer) $manufacturers[$key]["image_path"] = func_query_first_cell("SELECT image_path FROM $sql_tbl[images_M] WHERE id=".$manufacturer["manufacturerid"]); foreach($manufacturers as $key=> $manufacturer) $manufacturers[$key]["image_x"] = func_query_first_cell("SELECT image_x FROM $sql_tbl[images_M] WHERE id=".$manufacturer["manufacturerid"]); foreach($manufacturers as $key=> $manufacturer) $manufacturers[$key]["image_y"] = func_query_first_cell("SELECT image_y FROM $sql_tbl[images_M] WHERE id=".$manufacturer["manufacturerid"]); }
Then in skin/common_files/modules/Manufacturers/customer_manufacturers_list.tpl

In the foreach loop...
Code:
<img src="{$m.image_path|amp}" width="{$m.image_x}" height="{$m.image_y}" alt="{$m.manufacturer|escape}>
__________________
xcartmods.co.uk
Reply With Quote