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 e
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:
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 c
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
4 matches
Mail list logo
