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
