Mysql HELP PLEASE.....

[kiLLua]

do you know any tutorial for auto update of records??,

ex. i have a table with fields like PaymentCycle,monthlyRate,InstallationFee,Total and balance...every month a new record should automatically be added on that table..

ex. Records of

FIRSTNAME: Desiree LASTNAME: Anderson

PaymentCycle
--2006,July1-31

monthlyRate
--$1650

InstallationFee
--$300

Total
--$1950

on the month of august, the table should automatically be:

FIRSTNAME: Desiree LASTNAME: Anderson

PaymentCycle monthlyRate InstallationFee Total
--2006,July1-31 --$1650 --$300 --$1950
--2006,August1-31 --$1650 --$00 --1650

on the month of sept.

FIRSTNAME: Desiree LASTNAME: Anderson

PaymentCycle monthlyRate InstallationFee Total
--2006,July1-31 --$1650 --$300 --$1950
--2006,August1-31 --$1650 --$00 --1650
--2006,September ... ....

[gbshashi]

Create Job and Schedule job for once in a month