RE: [PHP-DB] How to get unique entries?
| From: | Bastien Koert | Date: | Wed, 03 Nov 2004 00:16:11 +0000 |
| Subject: | RE: [PHP-DB] How to get unique entries? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37161@lists.php.net to get a copy of this message | ||
select distinct(datefield) from ....
bastien
From: "Chris Payne" <cjp@planetoxygene.com> To: <php-db@lists.php.net> Subject: [PHP-DB] How to get unique entries? Date: Tue, 2 Nov 2004 17:24:48 -0500 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 simple, but cant remember the command. Thank you. Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.788 / Virus Database: 533 - Release Date: 11/1/2004