Re: newbie: how to return one iteration *per unique date (DAY!)* in a timestamp column?
| From: | Bastien Koert | Date: | Mon, 03 Aug 2009 03:33:31 +0000 |
| Subject: | Re: newbie: how to return one iteration *per unique date (DAY!)* in a timestamp column? | ||
| References: | 1 2 3 4 5 6 7 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46378@lists.php.net to get a copy of this message | ||
On Sun, Aug 2, 2009 at 11:13 PM, Govinda<govinda.webdnatalk@gmail.com> wrote:
>>
>> What does the resultset look like?
>
> I am getting every record in the table back
my bad, i reversed the mysql and php date function formats
try
SELECT distinct(
DATE_FORMAT( fieldname, '%Y-%m-%d' )
)
FROM table
ORDER BY field DESC
--
Bastien
Cat, the other other white meat