Seems like it should be easy...

[Peter Amisano]

   Yeah its pretty easy.  I wrote a script for a bed and breakfast that
   is tied to a calendar.  When you click on the day in the calendar the
   database is searched based on the date and tells you which rooms are
   reserved on that day.

   Date/Time functions are very easy in PHP.

   email me outside the group and I'll try and help you out.

   Pete

   --------- Original message --------
   From: "Seth Dimbert" <s.dimbert at fhmr.com>
   To: "KCLUG List" <kclug at kclug.org>
   Subject: Seems like it should be easy...
   Date: 01-09-03 03:45
   LUGNuts,
   I'm not a programmer.
   But it seems to me that it would be pretty easy to write a small Perl
   or php
   program to do what I want it to do.
   All I want is to have a small script that looks into a simple database
   (could be flat-file) and looks up information based upon the current
   time
   and date, then displays that information.
   Let me offer an example, because my actual need is too complicated to
   explain.
   Let's say that visitors to my website want to know what time my store
   is
   open, and what the "Sale Item of the Day" is. So, the database would
   look
   like this:
   Date Range Time Sale Item
   ---------------------------------------
   01/01 - 01/07 8:00 am Apples
   01/08 - 01/14 7:00 am Oranges
   01/15 - 01/21 4:00 pm Watermelon
   Etc...
   Is that clear? On January 3, when the page loads, the script runs and
   returns: "This week, we open at 8:00 am and Apples are on sale." On
   January
   8, the page would change to, "This week, we open at 7:00 am and
   Oranges are
   on sale."
   I need the script to check the current (server) time and date against
   the
   date range in the database every time it's called... Every time the
   page is
   called.
   Is that hard? As a non-programmer, it doesn't seem hard to me! :)
   Can anyone point me at a canned solution or help me create one?
   Thanks!
   -SD
   KC Linux Users Group -- to unsubscribe send mail to
   [1]majordomo at kclug.org
   Enter without the quotes in body of message "unsubscribe kclug"

   ________________________________________________
   This mail was sent by UebiMiau 2.5

References

   1. mailto:majordomo at kclug.org