Trying to only have unique items

[orangewhip]

Hi all,

I'm loading in dates that are in fields of a database, from these dates I only want to use the month and year that are unique. So if there were 3 items in the database 2 were from Sept 2001 and 1 was from Aug 2001, then all I want to end up with is Sept 2001 and Aug 2001.

I have a script where the dates are taken from a database, and then the month and year is stuck into a drop-down menu. I just don't want to have multiple versions on the same month and year in the drop-down menu, but to still have the full date in the database.

Any help would be great! Thanks!

[Anon]

You could:

$oldmonth = NULL;

search database order by date

Get month from database (numberical format)

if ($currentmonth != $oldmonth)
{
do your stuff with that variable.. put it in the drop down menu
$oldmonth = $currentmonthvalue;

}

That will give you one of each month in your drop down menu.

Hope that helps, im new to this. Feel free to email me if that wasnt clear enough.

ShuK

[hometoast]

If you're using mySQL to store your data try this link - you should be able to get the results you want directly from a query using these functions and a GROUP BY clause.

http://www.mysql.com/doc/D/a/Date_calculations.html

good luck.