i was wondering is someone could give me an example of how i could do this in sql query.
basically the application has a product table and when they are inserting they have the option to select monthly payments.
put in the start date so say 30/3/2013
what i need to do is show every month the payment to be paid then they can mark as paid and it will then go into the database table as paid. the thing is though i need the query to show this every month based on start date and remember there will be nothing in the payments table until it is paid. also the tricky part is if the user has not logged in for a few months it would need to show all months from the start date until current date.