Re: rss feed
Quote:
Originally Posted by cflsystems
It's that part of the query for the images
Code:
$q = "SELECT productid, productcode, product, add_date, xcart_products.descr, price, manufacturer, weight, image_type, filename, image_size
FROM xcart_products
LEFT JOIN xcart_pricing USING(productid)
LEFT JOIN xcart_manufacturers USING(manufacturerid)
LEFT JOIN xcart_images_T ON productid=xcart_images_T.id
WHERE forsale='Y'
ORDER BY add_date DESC
LIMIT 200";
You can either replace xcart_images_T with xcart_images_P which will use actual product images OR take the red out of the query but then there will be no images for the products
|
Steve,
I tried with xcart_images_P but then it's not created the feed with above line ! it's just creating single line feed with my site name !!
__________________
X-Cart: 4.7.7 LIVE
Skin:Ultra by xcartmods.co.uk
X-cart Modules: | ACR, Rich Google Search, Customer Testimonials | Cloud Search, | Websitecm: CDSEO (2.1.9)
---------------
Server: Linux
php: 5.3
mysql: 5.0.89
----------------
|