User monthly payment system
- by SomCollection
I want to create a monthly payment system for community members, at this point I have figured out that I need the following tables in my mysql database.
Edited
Users table
user_id, first_name, last_name
Payment table
payment_id,user_id,amount,due_date,payment_date,total
What I need to display list of users who did not pay 6th of every month.
How do I do this? And once the last day of the month is reached, how do I move to the next month?