Only Products With Images

[Guest]

I have around 20,000 products in my database, but only 3500 have images. How do i set my main page to only show the products with images under the New Products section.

 

Sorry if this was already covered, but i can't find any items relating to this request.

 

I changed my site to show only current months products and had to manually change the products_date_added field to match the current date, but if i miss doing this on the first day of the month then my site displays no products.

 

Any help would be greatly appreciated.

 

 

Miker........

[boxtel]

I have around 20,000 products in my database, but only 3500 have images. How do i set my main page to only show the products with images under the New Products section.

 

Sorry if this was already covered, but i can't find any items relating to this request.

 

I changed my site to show only current months products and had to manually change the products_date_added field to match the current date, but if i miss doing this on the first day of the month then my site displays no products.

 

Any help would be greatly appreciated.

Miker........

<{POST_SNAPBACK}>

 

 

simply add the where clause in the query :

 

where ...... products_image not null or products_image != ''

 

something like that.