Zen Cart Logo
Forums / General Questions / somwhat simple mysql query needed.

somwhat simple mysql query needed.

Locked

Views: 669

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
30 Sep 2009, 10:18 PM
#1
tony_sar avatar

tony_sar

Totally Zenned

Join Date:
Jul 2006
Location:
Montreal, Canada
Posts:
2,276
Plugin Contributions:
0

somwhat simple mysql query needed.

Hello all .
I need sql query to generate a list of products so i can upload them to a directory listing . i was asked to produce the result in following format and sequence

Product Name , Category 1, Category 2 , Category 3 , Description, Manufacturer, Part Number, Image ( absolute path to image ) , Product URL ( absolute path to product page ) , Price , Currency.

Any help on this sql query would be greatly appreciated.

Thanks

1 Oct 2009, 12:57 AM
#2
skipwater avatar

skipwater

Totally Zenned

Join Date:
Jun 2008
Location:
Washington, DC
Posts:
775
Plugin Contributions:
1

Re: somwhat simple mysql query needed.

Not exactly what you asked for but the query in this utility I posted can do what you want.
http://www.zen-cart.com/forum/showpost.php?p=663229&postcount=3

To run enter yoururl/cpl.php in you browser

Skip