Re: Display cell if dates are between 2 dates - help
| From: | Jason Wong | Date: | Sun, 17 Nov 2002 06:22:33 +0000 |
| Subject: | Re: Display cell if dates are between 2 dates - help | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-124772@lists.php.net to get a copy of this message | ||
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.
*/