Page 1 of 1
best way to setup yearly payment?
Posted: Mon Feb 16, 2009 12:12 am
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.
Re: best way to setup yearly payment?
Posted: Mon Feb 16, 2009 3:16 am
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..
Re: best way to setup yearly payment?
Posted: Mon Feb 16, 2009 11:52 pm
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.
Re: best way to setup yearly payment?
Posted: Sat Feb 21, 2009 5:58 am
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
Re: best way to setup yearly payment?
Posted: Tue Feb 24, 2009 2:03 am
by knightsjoker
yeah i wish. unfortunately her variables are not enough. i have to extract data from other places.
Re: best way to setup yearly payment?
Posted: Fri Mar 06, 2009 3:25 am
by knightsjoker
bump