[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 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

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 please remind me?  I know it was dead simple, but cant
 remember the command.

google  sql unique

-- 
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
--
/*
It is Fortune, not Wisdom, that rules man's life.
*/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php