here hi
"; /* TABLE_1에서 boncho_label로 약재명과 회사 data를 옮기는 과정 $sql = @mysqli_query($db_connect, "SELECT * FROM TABLE_1"); $i = 1; $query = 1; while($result = @mysqli_fetch_array($sql)){ $j = $result['COL_3'] * $result['COL_4']; echo $result['COL_1']."_".$result['COL_2']."_".$j."_".$i."
"; $query_1 = "INSERT INTO boncho_label (uid, name, company, price, unit_price, buying_weight, weight) VALUES ('$i', '$result[COL_1]', '$result[COL_2]', '$j', '$result[COL_3]', '$result[COL_4]', '$result[COL_5]')"; echo $query_1."
"; mysqli_query($db_connect, $query_1) or die("not writing"); $i++; echo $i."
"; } //sqli_free_result($result); //mysqli_close($db_connect); */ // 아래처럼 변수 선언을 하면 오류가 안남 $this_theme = isset($_GET['this_theme']) ? $_GET['this_theme'] : '1'; include('main_menu.htm'); if ( $this_theme == 1 ){ include('shortage_check.htm'); } else if ( $this_theme == 2 ){ include('total_stock.htm'); } ?>
_end