|
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 : |
<?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++;
}
?>