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

Reply via email to