Posted by David Quinton on 12/07/05 10:18

On 6 Dec 2005 23:25:26 -0800, google.20.jbloggs@xoxy.net wrote:

>Does anyone know of a ready-made system, or can think of how I could
>build one? I'm perfectly capable in PHP and MySQL, but conceptually I'm
>struggling here.

We started something a bit similar for a client a while ago.
Far be it for me to tell you how to do it but...

Try to think of it as storing _appointments_ rather than available /
unavailable blocks. With sensible indexing of the date/time fields,
and regular (automated?) purging of expired data, should be OK?

Also make uers' life easier by using a Javascript calendar to select
dates.
--
Locate your Mobile phone: <http://www.bizorg.co.uk/news.html>
Great gifts: <http://www.ThisBritain.com/ASOS_popup.html>

[Back to original message]