Need Expert Advice

[eluser]kre8ivdesigns[/eluser]
Ok so I am building a online booking site for a friend for her beach rental. I have everything done except the rate part.

My setup -> which I can change for rates

rates table {
rate_id
rate
begin_date
end_date
}

rate_dates {
date
rate_id
}

booked_dates {
date
client_id
}

so how do i check the booked dates to the rate date and place the rate in the booked date

Anyone would be great.....