Re: [PHP] Age from date field?

2003-10-12 Thread Eugene Lee
On Sun, Oct 12, 2003 at 02:09:38AM +0200, DvDmanDT wrote: : : Does anyone have a good solution on how to get the age of someone from a : date column in mysql... This is what I have, but it's not really the : truth... What's the right way to do it? : : floor((time()-$a[born])/(3600*24*365.25)) :

Re: [PHP] Age from date field?

2003-10-12 Thread Curt Zirzow
* Thus wrote Eugene Lee ([EMAIL PROTECTED]): On Sun, Oct 12, 2003 at 02:09:38AM +0200, DvDmanDT wrote: : : Does anyone have a good solution on how to get the age of someone from a : date column in mysql... This is what I have, but it's not really the : truth... What's the right way to do it?

Re: [PHP] Age from date field?

2003-10-12 Thread Eugene Lee
On Sun, Oct 12, 2003 at 02:49:53PM +, Curt Zirzow wrote: : * Thus wrote Eugene Lee ([EMAIL PROTECTED]): : On Sun, Oct 12, 2003 at 02:09:38AM +0200, DvDmanDT wrote: : : : : Does anyone have a good solution on how to get the age of someone from a : : date column in mysql... This is what I

[PHP] Age from date field?

2003-10-11 Thread DvDmanDT
Does anyone have a good solution on how to get the age of someone from a date column in mysql... This is what I have, but it's not really the truth... What's the right way to do it? floor((time()-$a[born])/(3600*24*365.25)) where $a[born] is the timestamp of the birthdate... Current query: