Thanks for the help, but I have been informed as to how to get through this
one.
I can use '...HAVING age...' instead of '...WHERE age...' and the correct
reults are returned.
matt
//t h r e e z e r o : : :
the mill, millstone lane, leicester, le1 5jn
e : [EMAIL PROTECTED] :: w : www.threezero.co.uk
t : 0116 225 0662 :: m : 07747 845690
: : : t h r e e z e r o//
> From: "Francois Legare" <[EMAIL PROTECTED]>
> Date: Sat, 14 Apr 2001 10:35:12 -0700
> To: "PHP DB" <[EMAIL PROTECTED]>
> Subject: RE: [PHP-DB] Newbie : URGENT : SELECT ... AS
>
> try using single quotes instead of double quotes:
>
> SELECT firstname, surname, dob,
> floor((to_days(curdate())-to_days(DOB))/365)
> AS age FROM artistes WHERE age = '25';
>
> Francois Legare
> [EMAIL PROTECTED]
> Vancouver BC Canada
> 604.261.1320
>
>> -----Original Message-----
>> From: Matt Coyne [mailto:[EMAIL PROTECTED]]
>> Sent: April 14, 2001 5:07 AM
>> To: PHP DB
>> Subject: [PHP-DB] Newbie : URGENT : SELECT ... AS
>>
>>
>> Hi all
>>
>> I am trying to make searches based on the age of a person. The db contains
>> only the Date of Birth.
>>
>> So...
>>
>> My first attempt was to try the following :
>> (this is all done in the command line on Win2000)
>>
>> SELECT firstname, surname, dob,
>> floor((to_days(curdate())-to_days(DOB))/365)
>> AS age FROM artistes;
>>
>> This works and returns all the values with the addition of an age column
>> with what appears to be the correct age.
>>
>> However...
>>
>> When I try adding a WHERE clause:
>>
>> SELECT firstname, surname, dob,
>> floor((to_days(curdate())-to_days(DOB))/365)
>> AS age FROM artistes WHERE age = "25";
>>
>> I get ERROR 1054: Unknown column 'age' in 'where clause'
>>
>> How am I to use this 'virtual' age column in my searches?
>>
>> I want to be able to search on exact and age ranges plus display
>> the age in
>> the returned results.
>>
>> Any ideas/feedback truly welcome, I am 'under the cosh' to get this done
>> asap!!! (as usual)
>>
>> TIA
>>
>> matt
>>
>>
>> //t h r e e z e r o : : :
>>
>> the mill, millstone lane, leicester, le1 5jn
>> e : [EMAIL PROTECTED] :: w : www.threezero.co.uk
>> t : 0116 225 0662 :: m : 07747 845690
>>
>> : : : t h r e e z e r o//
>>
>>
>>> From: Paul Burney <[EMAIL PROTECTED]>
>>> Date: Wed, 11 Apr 2001 19:07:02 -0700
>>> To: Mike Baerwolf <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>>> Subject: Re: [PHP-DB] select substring_index
>>>
>>> on 4/11/01 7:48 PM, Mike Baerwolf at [EMAIL PROTECTED] wrote:
>>>
>>>> SELECT substring_index( body, ". ", 2) FROM news;
>>>>
>>>> This works great from the mysql client but when I try it using php with
>>>> this:
>>>>
>>>> $result = mysql_query("SELECT substring_index(body, "." ,2) FROM news"
>>>
>>> The way you have this written, PHP is using the . for
>> concatenation. To fix
>>> the problem you need to alternate or escape the quotes, i.e. :
>>>
>>> $result = mysql_query("SELECT substring_index(body, \".\" ,2) FROM news"
>>>
>>> or
>>>
>>> $result = mysql_query('SELECT substring_index(body, "." ,2) FROM news'
>>>
>>> or
>>>
>>> $result = mysql_query("SELECT substring_index(body, '.' ,2) FROM news"
>>>
>>> Hope that helps,
>>>
>>> Paul Burney
>>> http://paulburney.com/
>>>
>>>
>>> --
>>> PHP Database Mailing List (http://www.php.net/)
>>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>>> For additional commands, e-mail: [EMAIL PROTECTED]
>>> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>>>
>>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]