View Single Post
  #1  
Old 03-28-2017, 09:56 PM
 
anandat anandat is offline
 

X-Adept
  
Join Date: Jan 2004
Posts: 914
 

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