View Single Post
  #11  
Old 06-06-2009, 01:20 AM
  amy2203's Avatar 
amy2203 amy2203 is offline
 

X-Wizard
  
Join Date: Jul 2004
Location: Watford, UK
Posts: 1,509
 

Default Re: How to display all products that do not have a thumbnail

you'll need to change the query in the prodwithoutimg.php file, try something like this,

Code:
SELECT netit_xcart_products.productid, netit_xcart_products.product FROM netit_xcart_products LEFT OUTER JOIN netit_xcart_thumbnails ON netit_xcart_products.productid = netit_xcart_thumbnails.productid WHERE netit_xcart_thumbnails.productid IS NULL

assuming your database uses netit_ as a prefix to it's tables. Otheriwse, check what your thumbnails table is called,
__________________
X-Cart version 5 (Previously 3.5-4)

Previous Versions included
BCSE Reward Points Mod
Altered Cart On Sale Mod
Wordpress Plugin

Please don't PM me for support. I help where I can on the forum and your question will more likely be answered there.

Shout me a Coffee!
Reply With Quote