On Saturday, 2. March 2002 09:32, John Hughes wrote: > I have a table with approximately 600 rows. Two of the fields are > "record_date" and "status" Every record has an entry in the > "record_date" in 0000-00-00 format. The "status" is either "input" > or "published" (I DID NOT create this colum as ENUM; those are simply
If you have a table with 600 records and you got only 17 and 33 rows, and status has only the conditional values "published" and "input" - something must be wrong. Maybe wrong table or other values in status. Try SELECT status, count(*) from yourtable group by status to see if there are any other values in status. Regards Georg sq, query --------------------------------------------------------------------- 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