|
|
Posted by Mitul on 12/16/57 11:58
ameshkin wrote:
> What I am trying to do, is...
>
> Find users in a database between two ages.
>
> $minage
> $maxage
>
> The birthdays of the users are in the database in this format
> 01-30-1980
>
> Now this function takes a birthday in this format 1980-01-30 and
> returns the age
>
> function birthday ($birthday)
> {
> list($year,$month,$day) = explode("-",$birthday);
> $year_diff = date("Y") - $year;
> $month_diff = date("m") - $month;
> $day_diff = date("d") - $day;
> if ($month_diff < 0) $year_diff--;
> elseif (($month_diff==0) && ($day_diff < 0)) $year_diff--;
> return $year_diff;
> }
>
> But what I need to do, is somehow only show the results from the
> database where the birthday is in between two different ages.
>
> How do I do this. My brain hurts enough already from writing the
> function above. Can anyone help?
Hi ameshkin.
Here is the approx solution to ur answer. You can do things by Query.
Here is the query for that You needs to just modify little by PHP and
Pass it on to the My-SQL u will get poper age.
SELECT name, birth, CURRENT_DATE,
-> (YEAR(CURRENT_DATE)-YEAR(birth))
-> - (RIGHT(CURRENT_DATE,5)<RIGHT(birth,5))
-> AS age
-> FROM pet;
/***** There is nothing impossible coz Impossible itself means I M
Possible. :)
Regards,
Mitul Patel
Navigation:
[Reply to this message]
|