<?include $_SERVER['DOCUMENT_ROOT']."/conf/conf_dir.php";?>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<?
	/*
	$query="select * from user_cash where flag='D' and enddate='2020-12-31'";
	$result= mysql_query($query,$db_con);
	$i=1;
	while ($row=mysql_fetch_array($result)) {
		echo $i.". ";
		echo $querys = "update user_cash set enddate ='2019-12-31' where id = '$row[id]'";
		echo "<br>";
		$results = mysql_query($querys, $db_con);
		$i++;
   //update user_cash set enddate ='2019-12-31' where flag='D' and enddate='2020-12-31'
	}*/
	/*
	$query="select * from user where auth_code='10' and m_enddate='2020-12-31'";
	$result= mysql_query($query,$db_con);
	$i=1;
	while ($row=mysql_fetch_array($result)) {
		echo $i.". ";
		echo $querys = "update user set m_enddate ='2019-12-31' where id = '$row[id]'";
		echo "<br>";
		//$results = mysql_query($querys, $db_con);
		$i++;

	}
	*/
	$QUERY_PAGE  = "SELECT * FROM `user_cash` WHERE admin_date LIKE '2021-08-31 %' and inning !=1";
	//$QUERY_PAGE  = "SELECT * FROM  user where auth_code = 10";

	$result= mysql_query($QUERY_PAGE,$db_con);
	$no =1;
	while($row = mysql_fetch_array($result)) {

	echo $no;
	echo $queryupok = "update user set m_startdate = '$row[startdate]',m_enddate='$row[enddate]' where id = '$row[user_id]' and auth_code=10";
	echo"<br>";
			//$queryupok_result = mysql_query($queryupok,$db_con);

	//echo "$file_query <br>";
	$no++;
	}

	//update user set m_enddate ='2019-12-31' where auth_code='10' and m_enddate='2020-12-31'


?>