Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Model and attributes SQL needed


volumax

Recommended Posts

Hi All,

 

I am not to good with sql queries, still learning, i need a query/code snippet to output a string in the following format, from the orders table:-

 

MODEL:DESCRIPTION:OPTION1:OPTION2:OPTION3:...

 

For each line on a customers order:

 

It is for export to accounts package

 

Example:-

 

0010:Widget:Black:XL

 

The rest of the string would be obviously quantity, ex tax price, etc...

 

Or has it already been done and I can't find it.

 

Thanks All

Andy

Literally, Laterally Thinking! If you cannot get through it, go round it.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...