RE: [PHP-WIN] Duplicate entry removal
| From: | Uttam | Date: | Thu, 27 Feb 2003 11:04:22 +0000 |
| Subject: | RE: [PHP-WIN] Duplicate entry removal | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-18728@lists.php.net to get a copy of this message | ||
isn't it better to just:
SELECT DISTINCT YEAR(<date>) FROM <table>;
regds,
-----Original Message-----
From: Michael Power [mailto:michaelpower@concentrix.co.uk]
Sent: Wednesday, February 26, 2003 17:10
To: php-windows@lists.php.net
Subject: Re: [PHP-WIN] Duplicate entry removal
Better yet define the required dataset with SQL to speed the whole
process
up:
"SELECT YEAR(your_date) FROM table_name GROUP BY your_date";
Cheers
Mike
> "Matt Hillebrand"
> array_unique()
>
> |-----Original Message-----
> |From: Per Christian [mailto:perchristian@myself.online.no]
> |
> |Hi
> |
> |I'm building a PHP project for fun, and are going to get some
> |dates from my database (mysql). The problem is that I only
> |want the year, but the date is in the format YYYY-MM-DD so I
> |get the whole column and remove the -MM-DD part, but now I
> |have a lot of the same year Is there a function or some code
> |that removes duplicate entries from a array?
> |
> |Best Regards,
> |Per Christian