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" <[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 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 > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php