PHP auto update person's age on their birthday?

  • Thread starter Thread starter Wes D
  • Start date Start date
W

Wes D

Guest
I currently have a table (mysql) full of members with one column being age and one column being their date of birth, stored as (mm-dd-yyyy). I was wondering if there is any way that the ages could be automatically updated on the person's birthday.

Example:
Sally Sue is 18 years old. Her birthday is on Dec 4, 1990. On Dec 4, 2009, I need her age to be automatically updated to age 19.

How can I do this in the most uncomplicated way. If there is no way around the complicated-ness, then I can deal with that.

ANY and ALL help would be GREATLY appreciated!!

If you need more details, please just let me know and I will provide more information.

THANK YOU!
After posting this question, my brain started working and I realized what I could do instead. Thank you for your help. Your Idea is where I was going with my thought process.
 
You wouldn't need to automatically update their age if you just stored their birthday and did some math to calculate their age based on today's date in your PHP code. It would change automatically.
 
Back
Top