add records, auto generate..

[kiLLua15]

need help, please..

we're doing a system for an accountant..we have records already for customers and each customer's should have many records and should auto generate every month..i have no idea about it, anyone here knows how to do it?..please help me guys..i have an attachment here if you look into it, you will see a table at the bottom, what we have to do is to add another record on that table.

as you can see i already have a record, and next month another record should be added there, the payment cycle should automatically be aug1-31 2006, and so on..so every month, another record should automatically be added on that table..please guys, help me..

one more thing, how can i add a record to each customer if they only have one record. we have a database. it has fields

id, Lastname, firstname, bill, payment received, payment received date..etc

and of course each id/customer can only have one record. how can i add records to those firlds?..please guys help me..im just new here...

[roooss]

it sounds to me like you need to look at your database and normalize it properly.... about the automatic part of it php is only dynamic when it gets processed its not constantly dynamic which is what youd need for the auto part. try looking at another way of developing this system maybe with java if it needs to be web based ir even visual basic if you want fast development