Re: [PHP-WIN] Duplicate entry removal

2003-02-27 Thread Michael Power
Depends if you want records with the same -MM-DD (my example) or (your example). After re-reading the original post it appears he only wants results as per your query, oops :) Cheers Mike > -Original Message- > From: Uttam [mailto:[EMAIL PROTECTED] > > isn't it better to just: >

RE: [PHP-WIN] Duplicate entry removal

2003-02-27 Thread Uttam
isn't it better to just: SELECT DISTINCT YEAR() FROM ; 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

Re: [PHP-WIN] Duplicate entry removal

2003-02-26 Thread Michael Power
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 build

RE: [PHP-WIN] Duplicate entry removal

2003-02-22 Thread Matt Hillebrand
array_unique() |-Original Message- |From: Per Christian [mailto:[EMAIL PROTECTED] |Sent: Saturday, February 22, 2003 7:56 AM |To: [EMAIL PROTECTED] |Subject: [PHP-WIN] Duplicate entry removal | | |Hi | |I'm building a PHP project for fun, and are going to get some |dates from my database