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
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:
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
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