[PHP-DB] How to get unique entries?

2004-11-02 Thread Chris Payne
Hi there everyone, Im listing entries by date in a dropdown box, but on some days there are 7-8+ dates the same, but I just need it to display each date ONCE in the dropdown, but for the life of me I cant remember the command to use to do this, can anyone please remind me? I know it was dead

Re: [PHP-DB] How to get unique entries?

2004-11-02 Thread Jason Wong
On Tuesday 02 November 2004 22:24, Chris Payne wrote: Im listing entries by date in a dropdown box, but on some days there are 7-8+ dates the same, but I just need it to display each date ONCE in the dropdown, but for the life of me I cant remember the command to use to do this, can anyone

RE: [PHP-DB] How to get unique entries?

2004-11-02 Thread Bastien Koert
select distinct(datefield) from bastien From: Chris Payne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] How to get unique entries? Date: Tue, 2 Nov 2004 17:24:48 -0500 Hi there everyone, I’m listing entries by date in a dropdown box, but on some days there are 7-8+ dates