Thanks for that. In fact, it was something else wrong and it does work. However, I
do have another
problem on this. The query is:
...WHERE TO_DAYS(NOW())+1>TO_DAYS(MyTable.MyField) ORDER BY MyTable.MyField DESC LIMIT
30";
however, the LIMIT seems to apply before the ORDER BY clause. How can
I'm trying to limit the results where a datatime field is later than todays date:
WHERE TO_DAYS(NOW())>TO_DAYS(MyTable.myfield)
doesn't appear to work. Should it? Should I not be nesting functions within an SQL
statement like
this?
Thanks in advance for any ideas.
John
--
PHP Database Mail
