mysql, PHP 0 vacancy calendar

[jpavery]

http://www.irishmountain.net/test.php
http://www.cddvdduplicators.com/vacancy.asp?id=190 (most likely down)

Hi Folks,
I built a vacancy calendar for my parents B&B in ASP & Access - I want to migrate it to MySQL and PHP - I've got the DB up - see first link, but I'm having difficulty making it look like a calendar.

Any have experience formating a table into a calendar.

I want each day to show the three suites and its status (either: booked, vacant or unknown)

Any resource people can point me too?

Paul

[ChrisRC]

I did find an Example Script (http://keithdevens.com/software/php_calendar/source) that covers the "calendar building" portion of your task.

You'd have to change the part near the end where the original author is actually adding data to the calender, but from an instructional perspective that seems like a good starting point.