PHP: Looping through and displaying data only if it's unique (dates)

Question

I need to display a list of dates from a database. There can be multiple records with the same date, but I only want the date to display once.

In other words, I need to only display unique dates. Any ideas?

user387302 · Accepted Answer · 2010-08-10 14:51:09Z

1

Have you tried using DISTINCT in your sql query?

answered Aug 10, 2010 at 14:51

user387302

4031 gold badge5 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

This would have been perfect, but I forgot to mention that they're unix timestamps. Thank you so much!

Ronn0 · Accepted Answer · 2010-08-10 14:51:58Z

0

You can build an array with the date as a key. And the results in tere.

$return = array();

foreach ($results as $result) {
    $return[$result['data']][] = $result;
}

where $return is an array with unique dates as a key.

answered Aug 10, 2010 at 14:51

Ronn0

2,2792 gold badges22 silver badges36 bronze badges

Community · Accepted Answer · 2023-11-21 15:10:29Z

0

If your dates are formatted the same you could build an array directly and use array_unique().

CommunityBot

11 silver badge

answered Aug 10, 2010 at 14:52

qnrq

1034 bronze badges