mysql query to generate product url with images ?
Basically I want to generate image site map for google since there is no module available for it at this time.
I want to generate following results.
http://www.mysite.com/product-url.html
http://www.mysite.com/images/T/product-thumbnail.jpg
http://www.mysite.com/images/D/product-detil-image-1.jpg
http://www.mysite.com/images/D/product-detil-image-2.jpg
Once I will get the result, I can export it into excel & will add necessary xml code to make it valid xml site map for google images.
If any one has got better idea then please suggest me
__________________
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
----------------
|