KGRKJGETMRETU895U-589TY5MIGM5JGB5SDFESFREWTGR54TY
Server : Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 DAV/2 PHP/5.2.17
System : Linux localhost 2.6.18-419.el5 #1 SMP Fri Feb 24 22:47:42 UTC 2017 x86_64
User : nobody ( 99)
PHP Version : 5.2.17
Disable Function : NONE
Directory :  /home/queenjbs/www/test/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/queenjbs/www/test/cash_inning_update.php
<?include $_SERVER['DOCUMENT_ROOT']."/conf/conf_dir.php";?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?

//전체 회원테이블에서 user_cash 테이블에 있는 inng을 id 순으로 1,2,3,4로 넣어준다. 이때 기준은 flag가 "D" 일때;
$QUERY_PAGE  = "
SELECT *
FROM user WHERE auth_code !=15
";
$result= mysql_query($QUERY_PAGE,$db_con);
$i = 1;
while($row = mysql_fetch_array($result)) {

	//user_cash 테이블
	$QUERY_PAGE2  = "
	SELECT *
	FROM user_cash
	WHERE
	user_id=$row[id] order by id asc
	";
	//echo $QUERY_PAGE2."<br>";
	$result2= mysql_query($QUERY_PAGE2,$db_con);
	if($result2){
		$k=1;
		while($row2 = mysql_fetch_array($result2)) {
			//echo $row[userid];
			$queryupok2 = "update user_cash set inning='$k' where id = '$row2[id]'";
			//echo "<br/>";
			//$queryupok_result = mysql_query($queryupok2,$db_con);
		$k++;
		}
	}
$i++;
}
?>

Anon7 - 2021