Hello,
I got the following error message from MySQL:
---
Query failed.
MySQL said:
Unknown column 'AGE' in 'where clause'
query = SELECT *, (Year(Now()) - Year(BDAY)) +
((DAYOFYEAR(Now())-DAYOFYEAR(BDAY))/365) as AGE FROM Katalog WHERE AGE >= 31
AND AGE <= 50 AND IS_MEM_EXP = 0 AND IS_OPEN = 1
Morten Twellmann wrote:
Hello,
I got the following error message from MySQL:
---
Query failed.
MySQL said:
Unknown column 'AGE' in 'where clause'
query = SELECT *, (Year(Now()) - Year(BDAY)) +
((DAYOFYEAR(Now())-DAYOFYEAR(BDAY))/365) as AGE FROM Katalog WHERE AGE >= 31
AND AGE <= 50 AND IS_MEM_
L PROTECTED]> cc:
Subject: [PHP-DB] Calculated field in
MySQL
08/10/2003 01:40
