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";