isn't it better to just: SELECT DISTINCT YEAR(<date>) FROM <table>;
regds, -----Original Message----- From: Michael Power [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 17:10 To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > | > |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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
