Posted by Richard Collyer on 10/21/53 11:15

Ryan A wrote:
> On 5/8/2005 5:33:46 PM, Richard Collyer (richard@firebadger.net) wrote:
>
>>Ryan A wrote:
>>
>>
>>>Hi,
>>
>>>Sorry I know this is OT but I'm hoping someone will still help...it
>
> should
>
>>>be quite simple :-)
>>>I have a field in the database called "age" which is a DATE field.
>>>
>>>I also have a webform where the user can select between which ages he
>
> wants
>
>>>the records shown...
>>>eg: if he types 23,25 then I should get all results where
>>>age >=23 and age <=25
>>>
>>>Thanks,
>>>Ryan
>>>
>>>
>>>
>>
>>What are you wanting? An sql query or a form?
>
>
>
> Hey Richard,
> Thanks for replying.
>
> I have the form without a problem, I dont know how to format the SQL
> query...
> the birthdates in the DB are like this:
>
> 12-01-1979
> 05-03-7955
> etc
>
> Thanks,
> Ryan
>
>
>

Your looking at something like. For ages between 21 and 23

$Upper = date("m-d-Y", mktime(0,0,0,date("m"),date("d"),date("y")-22));
$Lower = date("m-d-Y", mktime(0,0,0,date("m"),date("d"),date("y")-23));

$sql = "SELECT field1,field2,field3 FROM `table_name` WHERE `age`
BETWEEN " . $Lower . " AND " . $Upper;

$result = myqsl_query($sql);

etc....


Cheers
Richard

[Back to original message]