echajoa/manage/makeBaseData1.php

<?php

//include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
//include $_SERVER['DOCUMENT_ROOT'].ADMIN_PATH.'common/auth_chk.php';

	$connect = mysql_connect('cpro.interscope.co.kr','cpro','cprocpro') or die(mysql_error()); 
	mysql_select_db('cpro',$connect) or die(mysql_error()); 
	mysql_query("SET NAMES utf8");

//$r = mysql_query("SELECT * FROM code_master");
//$r = mysql_query("SELECT * FROM information_schema.columns WHERE table_schema = 'cpro' group by table_name order by table_name");
$r = mysql_query("SELECT * FROM code_master");
$i=1;
while($col = mysql_fetch_array($r)) { 
//	$table_name = $col[nm_code];
?>
<table>
	<tr>
		<td><?=$col[nm_name]?></td>
	</tr>
<?
//	$sql = "SELECT * FROM columns WHERE table_schema = 'cpro' and table_name = '$table_name' order by column_name";
//	echo $sql;

//	$rS = mysql_query("SELECT column_name FROM information_schema.columns WHERE table_schema = 'cpro' and table_name = '$table_name' order by ordinal_position");
//	$rS = mysql_query("SELECT column_name FROM information_schema.columns WHERE table_schema = 'cpro' and table_name = '$table_name' order by ordinal_position");
//	$j=1;
//	while($colS = mysql_fetch_array($rS)) { 

?>
	<!-- <tr>
		<td>&nbsp;&nbsp;<?=$colS[column_name]?></td>
	</tr> -->
<?
//		$j++;
//	}
?>
</table>
<?
	$i++;
}

mysql_close($connect);
?>