Re: Display cell if dates are between 2 dates - help
| From: | Ray Healy \(Data Net Services\) | Date: | Sun, 17 Nov 2002 10:31:44 +0000 |
| Subject: | Re: Display cell if dates are between 2 dates - help | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-124785@lists.php.net to get a copy of this message | ||
Dear Jason
The startdate and endate columns are "date" format - have any ideas what i
can do
Thanks for yout help
Ray
----- Original Message -----
From: "Jason Wong" <php-general@gremlins.biz>
To: <php-general@lists.php.net>
Sent: Sunday, November 17, 2002 6:22 AM
Subject: Re: [PHP] Display cell if dates are between 2 dates - help
> On Sunday 17 November 2002 04:10, Ray Healy \(Data Net Services\) wrote:
> > Dear all
> >
> > I'm trying to create a search function that can check the current day in
a
> > calendar against a mysql database where there is a startdate and enddate
> > and if the date is there then colour code the cell in the calendar.
> >
> > I have tried to use the following command
> >
> > $eventQuery = "SELECT title FROM prestigecal WHERE '$sql_currentday'
> > BETWEEN startdate AND enddate;";
> >
> > The database has an ID - title - startdate - enddate
>
> What types are the columns 'startdate' and 'enddate'?
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.biz
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
>
> /*
> You're ugly and your mother dresses you funny.
> */
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>