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