Re: Between Query (0T)
| From: | Ryan A | Date: | Sun, 08 May 2005 15:53:24 +0000 |
| Subject: | Re: Between Query (0T) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-214705@lists.php.net to get a copy of this message | ||
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
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.6 - Release Date: 5/6/2005