RE: New products

This message was sent from: General Support
http://forums.oscommerce.com/viewtopic.php?p=227627#227627
----------------------------------------------------------------

If you add:

and p.products_image != ''

to the end of your sql queries in your includes/modules/new_products.php, it will only display products with images on the front page.
Also, if you want to randomise what is shown to help the site look a bit different each time a user views it use:

where products_status = '1' and p.products_image != '' order by rand() limit " . MAX_DISPLAY_NEW_PRODUCTS);

Daithi.