Listing tours within month range.

[lahddah]

Hi. I've got a database of tours, with a field called 'Season'. The field is populated with a range of months that the tour is available. They are listed as such:

tourname = Tour1 Season = March - August
tourname = Tour2 Season = December - April

I've also got a month search drop down box and would like to make it so that if I chose April, I will get a listing of all tours offered in April. What is the best way to determine if a month lies within a range so searching for April will bring up both examples above?

Thanks, in advance!


~ lahddah

 

[DreXor]

store the month value as an integer, then when you retrieve it cast it as a date or convert it script side, then just use numeric comparisons for display

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!