1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71

<?
 if($mode == "step1"){

  include("./category/common.php");
  
  // Ã¹´Ü°è¿¡¼­ ÀÏ°ýÀûÀΠÀԷºκÐÀ» Ã¼Å©
  $totalsql       =    "select * from certinumManage " ; 
    $totalresult    =     mysql_query($totalsql);
    $totalnum       =     mysql_num_rows($totalresult);
    
    if($totalnum == 0){
  
  ################# ´ëºÐ·ù 
  
    $sql       =    "select * from cate1 WHERE category_name = 'ÇÁ·Î±×·¥»óÇ°' order by category_code  " ; 
    $result    =     mysql_query($sql);
    $sql_num   =     mysql_num_rows($result);
    
    if($sql_num > 0) {
        $i =1; 
        while($row = mysql_fetch_array($result) ) { 
            $largecode = $row[category_code];
            
            $sql_middle        =   "select * from cate2 where cate1_code = '$largecode' order by idx ";
            $result_middle     =   mysql_query($sql_middle);
            $result_middle_num =   mysql_num_rows($result_middle);
            
            if($result_middle_num > 0) { 

        while($row_middle = mysql_fetch_array($result_middle) ) {  
                    $middlecode = $row_middle[category_code];
                    $largecode  = $row_middle[cate1_code];
                
                    $sql_small      = "select * from cate3 where cate1_code='$largecode' and cate2_code='$middlecode' order by idx "; 
                    $result_small   = mysql_query($sql_small);
                    $result_small_num = mysql_num_rows($result_small);
                    
                    if( $result_small_num > 0){
                      
                       while($row_small = mysql_fetch_array($result_small) ) {  
                                $middlecode = $row_small[cate2_code];
                                $largecode =  $row_small[cate1_code];
                                $smallcode =  $row_small[category_code];
                                
                            $category_nameArr      =     explode( "->" ,$row_small[category_name]);
                     
                          $category_code      =    $largecode.$middlecode.$smallcode;
                          $insertQry          =  " INSERT INTO certinumManage VALUES ('','$category_code','$category_nameArr[1]','','','','','') "; 
                                                   MYSQL_QUERY( $insertQry );      
                    }
                }
            }        
      }
  }    
}
?>
<script>
 parent.msgAlert('1','ù´Ü°è°¡ ÀÏ°ýµî·Ï µÇ¾ú½À´Ï´Ù');
</script>
<?
  }
  else{
?>
<script>
 parent.msgAlert('2','À̹̠»ý¼ºµÇ¾ú½À´Ï´Ù');
</script>
<?    
    
    }
} 
?>