<?php

include 'config.php';

$query = "SELECT id, If(((To_Days(CurDate()) - To_Days(p.add_date)) <= 50), (40 -
  (To_Days(CurDate()) - To_Days(p.add_date))), '') AS NewDays
FROM wp_wpl_properties p
WHERE p.field_3150=1";


$result = mysqli_query($mysqli, $query) or die("SQL Error 1: " . mysqli_error());

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
	if ($row['NewDays'] < 0)
	{	
		//echo $row['NewDays']."<br>";
		$update_query = "UPDATE `wp_wpl_properties` SET field_3150=0 WHERE id=".$row['id'];
		echo $update_query;
	    $mysqli->query($update_query);
	}	
}

$result->close();
$mysqli->close();

?>