This one time, at band camp, Mark Maggelet <[EMAIL PROTECTED]> wrote:
> I don't know how you're charging weekly rates, but you could just > check if daysbooked>=7 and knock a percentage off total. I was thinking of having each day of a period charged as the weekly period rate divided by 7. But this seems a bit cumbersome. I guess I would need some sort of grouping for the rooms, such that rooms could be grouped together by price and number of bedrooms/beds and rooms could be assigned to groups. Kind regards Kevin -- ______ (_____ \ _____) ) ____ ____ ____ ____ | ____/ / _ ) / _ | / ___) / _ ) | | ( (/ / ( ( | |( (___ ( (/ / |_| \____) \_||_| \____) \____) Kevin Waterson Port Macquarie, Australia -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]