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 should work for yeah...
Basically, I convert it all to seconds and do the math...
On Sat, 2002-11-16 at 20: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
>
> 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 endate is a 10, 20 or 30 it also
>thinks that it is a 1, 2or 3
>
> Just in case it helps the full codede for this section is as follows :
>
> /snip
> $sql_currentday = "$year-$month-$zz";
> $eventQuery = "SELECT title FROM prestigecal WHERE '$sql_currentday' BETWEEN
>startdate AND enddate;";
> $eventExec = mysql_query($eventQuery);
> while($row = mysql_fetch_array($eventExec)) {
> if (strlen($row["title"]) > 0) {
> echo "<td bgcolor=\"red\" valign=\"middle\" align=\"center\"><font size=\"1px\"
>face=\"Verdana\">$zz</font></td>\n";
> $result_found = 1;
> /snip
>
>
> Thanks for any advice.
>
> Ray
--
.: B i g D o g :.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
