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

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

Bastien Koert

2004-11-02, 8:55 pm

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,
>
>
>
>I’m 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 can’t remember the command to use to do
>this, can anyone please remind me? I know it was dead simple, but can’t
>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
>

Sponsored Links