* [EMAIL PROTECTED] <[EMAIL PROTECTED]> :
> 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
> -Original Message-
> From: Ryan A [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 09, 2005 1:02 PM
> Luck and me? You dont know who you are talking to my friendI am
still
> on
> mysql 3.23 not even
> 4.1 !!!
TO_DAYS() works on 3.23 too ;-)
--
Med venlig hilsen / best regards
ComX N
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"
"Matthew Weier O'Phinney" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>* Ryan A <[EMAIL PROTECTED]> :
>> Than
On 5/9/2005 9:47:50 AM, Burhan Khalid ([EMAIL PROTECTED]) wrote:
> Ryan A wrote:
>
> >
>
> > 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")
Ryan A wrote:
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 " . $Lo
* Richard Collyer <[EMAIL PROTECTED]> :
> Ryan A wrote:
> > On 5/8/2005 5:33:46 PM, Richard Collyer ([EMAIL PROTECTED]) wrote:
> > > Ryan A wrote:
> > > > 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 ca
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
Ryan A wrote:
On 5/8/2005 5:33:46 PM, Richard Collyer ([EMAIL PROTECTED]) 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
On 5/8/2005 4:31:18 PM, Duncan Hill ([EMAIL PROTECTED]) wrote:
> On Sunday 08 May 2005 14:20, 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.
>
On 5/8/2005 5:33:46 PM, Richard Collyer ([EMAIL PROTECTED]) 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
* Ryan A <[EMAIL PROTECTED]> :
> 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
Just like you would in the example above -- only w
Hi,
On 5/8/05, Ryan A <[EMAIL PROTECTED]> 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.
are u storing in terms of Date of Birth??? if so the below lines u cannot
Hey,
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
Thanks,
Ryan
On 5/8/2005 4:28:44 PM, Andy Pieters ([EMAIL PROTECTED]) wrote:
> On Sunday 0
On Sunday 08 May 2005 14:20, 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.
http://dev.mysql.com/doc/mysql/en/comparison-operators.html
'BETWEEN'
--
PHP G
On Sunday 08 May 2005 15:20, 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
>
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
16 matches
Mail list logo