Avg + Sql + Drop Down Boxes ?

[alistair4267]

hi.

i have 3 drop downboxes with :

1 = DAY
2 = MONTH
3 = YEAR

i have an sql db set up with the different dates in them i need to no how i would go about getting an AVG number when a user select a date

e.g. i selected 3/3/2005 from the dropdown boxes and then press submit

how would i go about getting an AVG of the date i entered and returning it ???

please help

alistair

[szlamany]

There is a DATABASE DEVELOPMENT forum that this thread would probably make more sense to be in - if you want it moved - PM MartinLiss or some other moderator.

You need to give some idea as to what you tables/columns are that the query would be against - this doesn't sound too complex - but I don't have enough information to venture a guess.