Custom Script Required Please

[MikeWarner]

Hi. I run a car club and the website for the club. We are using the paid subscriptions feature and have asked people who have joined through this to fill in extra member profile fields such as full name, address, phone number etc.

What I need is a script that will show all users ordered by date who have subscribed and thier extra member info. Best why would be comma delimited plain text output. I need this to paste directly into Excell in order to print labels to send of membership packs etc.

I am completely lost on how to do this, so any help will be very very much appreciated.

Many thanks.

Mike

[Code Monkey]

Have you checked if you can get the info from paypal or whatever payment service you are using?

[Code Monkey]

You just need to grab the info from the different tables invloved. vb_user, vb_userfield, and vb_subscriptionlog. Join them together with userid and output the data as you wish.

[MikeWarner]

Are there any tutorials anywhere on how to do this?