Hi i have a problem
i'm sure i don't know php so good
but i really like it...
i got 2 tables lesson:
Fields:
LessonDate
TeacherName
StudentName
PackageName
TypeOfPackage
QuantityLessons
LimitLessons
Price
___
Payment:
Fields:
Status (Paid/Unpaid)
LessonDate
TeacherName
StudentName
PackageName
TypeOfPackage
PaidTotal
_
Sample
PackageName: Silver
TypeOfPackage: Boys
QuantityLessons: i need to put autonumber (start from (1)
LimitLessons: 10
Price: 250
_____
My question Is
how can i add auto number and when it meet LimitLessons number
Alert For The Next Payment, and reset QuantityLesson Field to 1 after recive Payment
Thank you