I have two tables in mysql using php> 1) Consumers 2) Monthly Billing
In Consumers that table contains about 100s of Consumers , and it increase monthly.
2) Monthly Billing for Billing.
What i want to do ?
Is there are any way that i can generate monthly billing automatically or any other simple way. My Consumers are in 100s or may be 1000s so i can't just go to add new bill for every consumers it will takes days.