Re: Advice on Calculating Attendance within dates needed
Posted: Wed Aug 05, 2015 10:19 am
The membership is for a year.
So they attend the eligible amount of events, and then before a "member" for a year from that date.
Once that date expires, I need to base the "new year" to check if they have done (all we did earlier)....
At the moment it's based on either their Join date, or their Membership date. But if the membership expires.. I'm not sure on what date to based it on....Sorry this isn't making much sense..
This is the problem bit. I need to base it on $datestart.
So they attend the eligible amount of events, and then before a "member" for a year from that date.
Once that date expires, I need to base the "new year" to check if they have done (all we did earlier)....
At the moment it's based on either their Join date, or their Membership date. But if the membership expires.. I'm not sure on what date to based it on....Sorry this isn't making much sense..
Code: Select all
$querydiary = "SELECT * FROM diary WHERE memberid =:memberid AND dateattended >= '$datestart' ORDER BY dateattended ASC";