The startdate and endate columns are "date" format - have any ideas what i
Thanks for yout help
----- Original Message -----
From: "Jason Wong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
> > 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
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php