X-Cart forums - 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}>