--- Georg Richter <[EMAIL PROTECTED]> wrote: > 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 > > -------------------------------------------------------------------
No, the number of rows is correct. The database contains 33 days of information. The GROUP_BY in the query combines the records where the date is equal. __________________________________________________ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com --------------------------------------------------------------------- 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
