X-Cart forums - How to display all products that do not have a thumbnail

Page 2 of 2

Show 40 posts from this thread on one page

X-Cart forums (https://forum.x-cart.com/index.php)

- Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)

- - How to display all products that do not have a thumbnail (https://forum.x-cart.com/showthread.php?t=18136)

amy2203

06-06-2009 01:20 AM

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,

amy2203

06-06-2009 01:30 AM

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

The query needed for 4.1 is probably

Code:

SELECT xcart_products.productid, xcart_products.product 

FROM xcart_products 

LEFT OUTER JOIN xcart_images_T ON xcart_products.productid = xcart_images_T.id 

WHERE xcart_images_T.id IS NULL

ORDER BY add_date DESC

looks like xcart_thumbnails is an old table no longer used,

AusNetIT

06-08-2009 03:10 AM

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

HI Amy,

All my images are in xcart\images folder so i think we need to create different query to achive this isn't it?

Thanks.

amy2203

06-08-2009 03:13 AM

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

they will still need to be referenced in the database,

royng

06-25-2009 11:00 AM

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

I am a newbie. I am really lost, Can someone tell me which file need to be modify and what need to be create? Plus location of the files too. Thanks!

royng

06-25-2009 11:04 AM

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

Carlisleglass, I like your site. How did you add the view all option to your product's page? Is that alot of work? Please let's me know the step by step. Thanks!

All times are GMT -8. The time now is 08:04 AM.

Page 2 of 2

Show 40 posts from this thread on one page