okay, this is a follow-up to my past email...
since I KNOW more than 122 people have signed up today, I did the following
query:
SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit
200;
there are at LEAST 200 people that have signed up today. however, when i do:
SELECT count(*) FROM members WHERE signup_date = now();
I only get 122 results! And YES, I have tried "2001-03-01" instead of
"now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever.
Does anyone have any idea what could be going on? I run this query quite
often, is it possible the result is somehow being saved in a buffer? Should
I shutdown the mysql server and restart it?
---------------------------------------------------------------------
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