Re: [PHP] Display cell if dates are between 2 dates - help

2002-11-17 Thread Ray Healy \(Data Net Services\)
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

Re: [PHP] Display cell if dates are between 2 dates - help

2002-11-17 Thread Jason Wong
On Sunday 17 November 2002 18:31, Ray Healy \(Data Net Services\) wrote: The startdate and endate columns are date format - have any ideas what i can do ...This seems to work BUT if the date in the database is a single number i.e. 0 to 9 it cannot dispaly it and also if the startdate or

Re: [PHP] Display cell if dates are between 2 dates - help

2002-11-16 Thread BigDog
This is how i deal with dates... $date = date in the database. $today = strtotime( gmdate( Y-m-d ) ); $spd= 60 * 60 * 24; // seconds per day $fdate = strtotime( substr( $date, 0, 10 ) ); $future = ( $fdate - $today ) / $spd; do the comparision with $future and it

Re: [PHP] Display cell if dates are between 2 dates - help

2002-11-16 Thread Jason Wong
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