X-Cart forums

[amy2203]

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

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]

The query needed for 4.1 is probably

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]

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]

they will still need to be referenced in the database,

[royng]

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]

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!