Re: Duplicates

select distinct Date from table_name where name = 'Test'; Jeff "Chris Grigor" <chris@calibre To: "PHP Gen" <php-general@lists.php.net>, "PHP DB" .co.za> <php-db@lists.php.net> cc: 10/23/2002 Subject: [PHP-DB] Duplicates 08:04 AM Howdi all, How can you list the contents of a table and skip duplicate Dates?? eg select Date from table_name where name = 'Test'; ---------------------------------------- |Date| ---------------------------------------- 2000-01-01 2000-01-02 2000-01-02 <------- How would you get rid of this duplicate date (without deleting it ;-))? I want to just get a list of dates in the table that querys have been inserted, but not duplicate dates... Say for instance I had 1 entry on 2000-01-01, and I had 10 entrys on 2000-01-02 I want it to tell me that there is a date for 2000-01-01 and a date for 2000-01-02, not for it to tell me there is 10 entrys on 2000-01-02 Any help would be appreciated Many Thanks guys -------------------------------------- Chris Grigor Calibre Clinical Consultants -------------------------------------- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php