best way to setup yearly payment?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
knightsjoker
Forum Newbie
Posts: 13
Joined: Fri Dec 26, 2008 2:00 am

best way to setup yearly payment?

Post by knightsjoker »

Hi guys,

I was wondering what's the best way to keep yearly payment on mysql.
I've setup 1 table so far to keep the individual data. But I'm thinking of making another table just for the yearly payment. I'm stump on the best way to setup the yearly payment table. Just can't get my head around it. Need fresh brain.
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: best way to setup yearly payment?

Post by onion2k »

You'll need to explain the problem in a bit more detail. What do you mean by "yearly payment"? I can think of at least half a dozen different things you might want..
knightsjoker
Forum Newbie
Posts: 13
Joined: Fri Dec 26, 2008 2:00 am

Re: best way to setup yearly payment?

Post by knightsjoker »

ok well i need to keep track of their yearly payment to determine if they're a member until next year.

for example now we're collecting the fee.

we entered in the system their particulars and payment info and payment date.
next month we'll be checking the dbase who has paid who hasn't and send out reminder emails.
lastest payment date would be this may.
if they haven't paid by june their status becomes non active member (not deleted - still keep previous records just in case they decide to join again in the future)

and then the cycle continues the next year.

currently i really want to strangle the previous IT person who didn't create database for this. she kept the database on an excel file.
Mark Baker
Forum Regular
Posts: 710
Joined: Thu Oct 30, 2008 6:24 pm

Re: best way to setup yearly payment?

Post by Mark Baker »

knightsjoker wrote:currently i really want to strangle the previous IT person who didn't create database for this. she kept the database on an excel file.
There's always the option of reading the data from your Excel file without the need to transfer the data into MySQL, as long as the Excel file itself is accessible to your PHP scripts
knightsjoker
Forum Newbie
Posts: 13
Joined: Fri Dec 26, 2008 2:00 am

Re: best way to setup yearly payment?

Post by knightsjoker »

yeah i wish. unfortunately her variables are not enough. i have to extract data from other places.
knightsjoker
Forum Newbie
Posts: 13
Joined: Fri Dec 26, 2008 2:00 am

Re: best way to setup yearly payment?

Post by knightsjoker »

bump
Post Reply