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.
best way to setup yearly payment?
Moderator: General Moderators
-
knightsjoker
- Forum Newbie
- Posts: 13
- Joined: Fri Dec 26, 2008 2:00 am
Re: best way to setup yearly payment?
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?
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.
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?
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 scriptsknightsjoker 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.
-
knightsjoker
- Forum Newbie
- Posts: 13
- Joined: Fri Dec 26, 2008 2:00 am
Re: best way to setup yearly payment?
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