Hi, I have a simple script that compares two dates as below:
$currentDate = mktime(date("Y-m-d H:i:s"));
echo "Current date in seconds: ".$currentDate."<p>";
$sqlOrder = "SELECT orders.orderID, orders.clientID, orderExpiry FROM orders INNER JOIN accessLevels ON orders.orderID = accessLevels.orderID WHERE active=1";
$resOrder = mysql_query($sqlOrder);
while ($dataOrder = mysql_fetch_assoc($resOrder))
{
$dateExpiry = $dataOrder['orderExpiry'];
echo "Expiry date: ".$dateExpiry."<br>";
$dateExpiry = mktime($dateExpiry);
echo "Expiry date in seconds: ".$dateExpiry."<br>";
if ($currentDate > $dateExpiry)
{
echo "Order expired - ORDER ID: ".$dataOrder['orderID']."<br>";
$sqlExpire = "UPDATE accessLevels SET active = 0 WHERE orderID = ".$dataOrder['orderID'];
//$resExpire = mysql_query($sqlExpire);
echo $sqlExpire."<p>";
}
else
{
echo "<font color='red'>Order not expired - ORDER ID: ".$dataOrder['orderID']." -- ".$dateExpiry."</font><p>";
}
}
However, this outputs some very strange results (http://www.householdstaffonline.com/accessLevel_cron.php) It would appear that some dates are correctly processed but not others, i.e. Order ID 29 should all be "expired".
What have I done wrong?
Thanks.
