select distinct(datefield) from ....
bastien
From: "Chris Payne" <cjp@xxxxxxxxxxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Subject: 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
