Ryan A wrote:
clip
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 .
On 5/9/2005 9:47:50 AM, Burhan Khalid ([EMAIL PROTECTED]) wrote:
Ryan A wrote:
clip
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
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] :
Thanks for
-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
* [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
even
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
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
the
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
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 08
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 do
* 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 with dates that
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.
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
clip
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;
* 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 called age which is a
16 matches
Mail list logo