age caluculation in php...

[Suneetha Reddy]

I have stored date of birth of my users into my database..
I want to calculate their age according to the database dob field...
Please help me..

Thanks..

[nav33n]

http://dev.mysql.com/doc/refman/5.0/en/date-calculations.html

[nav33n]

SELECT DATE_FORMAT( FROM_DAYS( DATEDIFF( NOW( ) , "1978-03-28" ) ) , '%Y' ) +0 AS age

Even this works. Just replace the date (1978-03-28) with the date of birth column.

[Shanti C]

Hi Naveen...

I have done a code with your reference..
But i got error in mysql:

Error
SQL query:

"SELECT fname,date,curdate(),(YEAR(curdate())-YEAR(date))-(RIGHT(curdate(),5)<RIGHT(date,5)) AS age FROM date_profiles ORDER BY fname";

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"SELECT fname,date,curdate(),(YEAR(curdate())-YEAR(date))-(RIGHT

[nav33n]

date is a mysql reserved keyword. You should use `` around reserved keyword fields to make them work.

[Shanti C]

date is a mysql reserved keyword. You should use `` around reserved keyword fields to make them work.

If dont mind...
Please edit my code and resend...
Thank you...

[nav33n]

replace date with `date`.

[Shanti C]

date is my database field, and i declared it as varchar...
Is it a problem?

[nav33n]

Yes. date is a mysql keyword and whatever the datatype is, its still a problem.

[Shanti C]

Yep..
I changed my date to date1..
Still i got the error...

[nav33n]

Then maybe something is wrong with your query.
I tried it and it worked !

SELECT uname,datej,curdate(),(YEAR(curdate())-YEAR(datej))-(RIGHT(curdate(),5)<RIGHT(datej,5)) AS age FROM members ORDER BY uname

[Shanti C]

i got the correct output...
What my mistake is:
i have declared dob with varchar,after i changed it to date,correct output came...

Thank you naveen....

[nav33n]

Great! :)

[Shanti C]

Hello nav..
In the above code CURDATE is database field or its todays date...tel me.

[nav33n]

:) Its a mysql function. http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_current-date