RE: [PHP-DB] Duplicates

select date from table_name where name='test' GROUP BY date -----Original Message----- From: Chris Grigor [mailto:chris@calibre.co.za] Sent: woensdag 23 oktober 2002 14:04 To: PHP Gen; PHP DB Subject: [PHP-DB] Duplicates 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