Thread: rss feed
View Single Post
  #12  
Old 02-06-2011, 08:54 PM
 
anandat anandat is offline
 

X-Adept
  
Join Date: Jan 2004
Posts: 914
 

Default 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
----------------
Reply With Quote