How to clear cache in php script...

[slaterino]

Hi,

I've got a script that generates a list of the next seven days. However, as today becomes tomorrow it seems that the dates are not changing automatically as they should do! Does php sometimes store data in a cache. How can I reset this so that this won't happen?

 

I'm using this query to capture the date, and do a bit of coding with it, and then I'm echo'ing the date later in the script. How can I make sure it changes as soon as midnight hits?

 

$sql = "SELECT post_id, 
DATE_FORMAT(start,'%m/%d/%Y') AS eventStart, 
DATE_FORMAT(end,'%m/%d/%Y') AS eventEnd,
DATE_FORMAT(CURDATE(),'%m/%d/%Y') AS today,
DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL 7 DAY),'%m/%d/%Y') AS endWeek 

FROM   wp_ec3_schedule s
JOIN   wp_posts p ON p.ID = s.post_id
WHERE   post_status = 'publish' ";
$clause = array();
for( $i = 0; $i < 7; $i++ ) {
$clause[] = "DATE_ADD(CURDATE(), INTERVAL $i DAY) BETWEEN DATE(start) AND DATE(end)";
}

$sql .= "AND (" . implode(' OR ', $clause) . ")"; 
$sql .= ' ORDER BY start DESC';
$result = mysql_query($sql) or trigger_error($sql . ' has failed. <br />' . mysql_error()); //pull data from database.

[xyph]

Echo your $sql variable. It might help us find out what's going on.

 

Also, midnight on your computer might be different from that of your server, or even MySQL.