Hi

I'm needing help with an asp script

I want to loop through a number of records all with a date column. and output the following result organised accoding to the date

2010
January
February
March
etc...

2009
January
February
March
etc...


and when i click on the month is will display a list of records that fall under that month and year.


any advice would be appreciated.

thanks in advance
Ryan

I dont understnad your quesiton, im not sure anybody would with the limited information you posted. Help others help yourself...

__________________
Wind is your friend
Matt

wow ok i thought it was pretty well explained....anyway will try again.

Lets say i have 1500 records in a database, each record has a date. dates are obviously different.

I need to sort/Group those 1500 records by year and then month. So using the date i need to check the year and month of each record.

but I want to sort them by year and date. The HTML will out put as follows:

2010
January
February
March
etc...

2009
January
February
March
etc...

so if there is no record out of the 1500 records that has a date that falls in February 2009 then the February will not display. Same for the year, if no records out of the 1500 have a year of 2010 then 2010 and its months do not display.

when you click on one of the months "March under 2009 for example" it will display the records whose date falls within that year and month.

hope that makes more sence.

no you wernt...

What do you want the query to get the record set, the code to loop through the recordset or someone to write it all.......

You should indicate which part you are stuck on, show some code, have you attempted this at least?

__________________
Wind is your friend
Matt

lol mate can feel your irritation with us noobs :)

I just need the loop part