Quote Originally Posted by bislewl View Post
is it pulling in the product_images? If not is the product images in the select statement?
it should look like:
PHP Code:
$products_query_raw "select p.products_id, products_quantity, pd.products_name, p.products_model, p.products_price, (products_quantity * p.products_price) as total, categories_name, p.products_quantity_order_min, m.manufacturers_name, p.products_image from " TABLE_PRODUCTS " p left join " TABLE_PRODUCTS_DESCRIPTION " pd using(products_id) LEFT JOIN " TABLE_CATEGORIES_DESCRIPTION " cd ON(cd.categories_id = p.master_categories_id AND cd.language_id = '" $lang_id "') left join " TABLE_MANUFACTURERS " m using(manufacturers_id) " $db_category_where " group by p.products_id order by " $sort " " $dir
try using this line instead
PHP Code:
<td class="dataTableContent" align="center"><a href="<?php echo DIR_WS_CATALOG_IMAGES.$products->fields['products_image']; ?>" target="_blank">Link</a></td>
That should resolve the /admin issue
Hi, thanks for the quick reply.
I added the code given by you .
It is now showing the links for product images in the ADMIN panel. But when I down load the ACTIVE products report, the product images column has BLANK values.. Nothing shows there.