Re: Between Query (0T)
| From: | Matthew Weier O'Phinney | Date: | Mon, 09 May 2005 13:00:51 +0000 |
| Subject: | Re: Between Query (0T) | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-214766@lists.php.net to get a copy of this message | ||
* andreja@beogradnet.com <andreja@beogradnet.com> :
> I am not sure
> but maybe something like this is posible
>
> $current_year = date(Y);
> $qry = "SELECT * FROM
>
table
> WHERE ($current_year-YEAR(birthday)) BETWEEN 25 AND 26"
No -- because this incorrectly identifies somebody born on June 14 as 26
even though today is May 9, and they're still 25.
> "Matthew Weier O'Phinney" <matthew@garden.org> wrote in message
> news:slrnd7sdct.2h3.matthew@webmaster2.garden.org...
> > * Ryan A <ryan@coinpass.com> :
> > > Thanks for replying.
> > >
> > > > SELECT * FROM
> > > > table
> > > > WHERE age BETWEEN 25 AND 26;
> > >
> > > I knew the above, but how do i use it with my date field when i have
> > > birthdates like this:
> > > 01-01-1969
> > > and 03-05-1955
--
Matthew Weier O'Phinney | WEBSITES:
Webmaster and IT Specialist | http://www.garden.org
National Gardening Association | http://www.kidsgardening.com
802-863-5251 x156 | http://nationalgardenmonth.org
mailto:matthew@garden.org | http://vermontbotanical.org