I should note, however, that this query works FINE: mysql> select count(*) from members where signup_date = '2001-02-28'; +----------+ | count(*) | +----------+ | 732 | +----------+ This APPEARS to work, but the "127" should be more like 420 mysql> select count(*) from members where signup_date > '2001-02-28'; +----------+ | count(*) | +----------+ | 127 | +----------+ As opposed to before, when I got an error doing the following query, it now works, but does not return the correct value. I shut-down and restart the server, which is why I'm guessing I no longer get the error: mysql> select count(*) from members where signup_date = now(); +----------+ | count(*) | +----------+ | 127 | +----------+ Could this have anything to do with mysql caching this query somehow? I don't see how it works for one date, and not the others? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
