Only display products with images.

[Ajeh]

If you look at the table:
products

in your database ... on these Products with out images, are you saying the field:
products_image

is empty or does it contain your image for the no_picture.gif ...

So something like the module for the New Products, you can use your templates and overrides for:
/includes/modules/new_products.php

copying to your:
/includes/modules/your_template_dir/new_products.php

and add a condition to the SELECT statements ...

  $new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
                                p.products_date_added, p.products_price, p.products_type, p.master_categories_id
                           from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                           where p.products_id = pd.products_id
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                           and p.products_image !=''
                           and   p.products_status = 1 " . $display_limit;

and the other SELECT statement:

    $new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
                                  p.products_date_added, p.products_price, p.products_type, p.master_categories_id
                           from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                           where p.products_id = pd.products_id
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                           and p.products_status = 1
                           and p.products_image != ''
                           and p.products_id in (" . $list_of_products . ")";

[Tantirx]

Worked perfectly!!! You rock!!

[Ajeh]

Thanks for the update that this works for you ...