Need script to expire membership when URL visited.

I started out trying to do this, but my knowledge of PHP is too limited to figure it out.

What I need is a script that when visited will expire a members active subscription.

That information is stored with a payment_id in the payments table.

I'm thinking it might be as simple as getting the logged in users payment_id, then setting the expiration date to any date in the past.

If you're up for the job or have any ideas let me know.

You can contact me at Kencinnus.com and we can discuss your project.

Thanks, already got it done!