Date of Birth to Age

Pauloc,

Collecting and displaying users date of birth should be easy with phprunner. Just use the standard features.
Assuming you have mysql for your data baseTo display users curent age, modify the sql query to include the following calculated value for the age of the user...
DATEDIFF(now(),dateofbirth)/365 AS ageinyears
This provides the age of the user in years.

Your overall query will end up looking something like:
SELECT `dateofbirth`, DATEDIFF(now(),`dateofbirth`)/365 AS ageinyears FROM users
where dateofbirth is a field in a table called users.

Hope this helps.
Giles.

I wish to

• collect users data of birth
  
• display users date of birth
  
• display users current age
  Thanks