This topic is locked

View with query by date

11/16/2008 7:26:43 AM
PHPRunner General questions
P
punch author

Hello,
i try to build a view, which should query files by date.
E.G. i will query all files, where the entry in a date-field is older than the actual date.
I tried some variants like "select * from table where datefield < date ("d. m. Y").
PHPRunner doesn`t accept this code. How can i build a query which uses the actual date?
Punch

J
Jane 11/17/2008

Hi,
use MySQL functions, not PHP:

select * from table where datefield < CURDATE()



http://dev.mysql.com/doc/refman/5.0/en/dat...-functions.html

P
punch author 11/17/2008

Hello Jane,
great, that works.
Thanks for fast support.
Punch