Daily order download in delimited format

[Guest]

I know this is a dumb question but I'm still new to PHP. I need to be able to download all orders by date (once a day) into a delimited format (tab, or pipe preferably) but I haven't been able to write the query correctly. I need it to pull all the info that's in a normal order, ex. something like:

ORDER#1|DATE|NAME|ADDRESS|PHONE|D.O.B|EMAIL|Total|CC#|Exp|COMMENTS|ProdOrdered1|

ProdOrdered2|ProdOrdered3|ProdOrdered4.... ORDER#2|DATE|NAME|ADDRESS|PHONE|D.O.B|EMAIL|Total|CC#|Exp|COMMENTS|ProdOrdered1|

ProdOrdered2|ProdOrdered3|ProdOrdered4....

If anyone can help me out that would be great, if not, well, I'll keep trying.... :wink:

[Guest]

Still stuggling with this, just getting it to print out on a page that they could copy and paste would even work, has anyone done something close to this?

[Guest]

I have made a small script to do this, and am making some additions to that it will email them out as a CSV text file attachment every night. I you would like the code (not ready to be released), please feel free to email me.

 

Thanks,

Zac

[peachnut]

Could you please email it to me also?

 

Thanks,

Chris Behnke

chris@delightfulgourmetwonders.com

 

 

I have made a small script to do this, and am making some additions to that it will email them out as a CSV text file attachment every night. I you would like the code (not ready to be released), please feel free to email me.

Thanks,

Zac

[alacour]

I would also like a copy.

anthony@agcomputers.net