database

Question

hello every body,

i am working on "Rent a car" project i have Table "Rates" with following fields in my database.

1)    2_6daysrent  =$20

2)    7_13daysrent =$18

3)     13+daysrent =$15

 

on aspx page i enter startdate and enddate for rent how it will match database fields and fetch  the total rent and total days on aspx page.

Thanks if some body solved it.