<?include $_SERVER['DOCUMENT_ROOT']."/conf/conf_dir.php";?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?
$QUERY_PAGE  = "
SELECT * 
FROM user_cash
WHERE 1 =1
AND flag = 'D'
AND admin_date >= '2014-01-01'
AND admin_date <= '2014-04-02'
AND enddate <= '2015-01-01 '
ORDER BY `user_cash`.`enddate` ASC";
$result= mysql_query($QUERY_PAGE,$db_con);
$i = 1;
while($row = mysql_fetch_array($result)) {
	
	$admin_date = substr($row[admin_date],0,10);
	$m_modified_tmp = explode("-","$admin_date");
	$tmpyearp=$m_modified_tmp[0]+1;
	$p_modified = $m_modified_tmp[0]."-".$m_modified_tmp[1]."-".$m_modified_tmp[2];
	$a_modified = $tmpyearp."-".$m_modified_tmp[1]."-".$m_modified_tmp[2];
echo $i." ";
echo $queryupok1 = "update user set m_startdate ='$p_modified' , m_enddate ='$a_modified' where id = '$row[user_id]'";
		//$queryupok_result = mysql_query($queryupok1,$db_con);
echo "<br/>";
echo $queryupok2 = "update user_cash set startdate='$p_modified' , enddate='$a_modified' where id = '$row[id]'";
echo "<br/>";
		//$queryupok_result = mysql_query($queryupok2,$db_con);
$i++;
}
?>