컬럼이 비슷한 테이블을 비교합니다.

<?php
include '_common.php';
$get_constant = 'constant';
$this_db= G5_MYSQL_DB;

?>
<div >
<form >
<input type="text" name="tbl1" value="<?=$tbl1?>" placeholder="table1" />
<input type="text" name="tbl2" value="<?=$tbl2?>" placeholder="table2" />
<input type="submit" />
</form>
</div>
<?php

if( $tbl1 & $tbl2 ) {

echo '<table>';

$sql="SELECT a.COLUMN_NAME acols, b.COLUMN_NAME bcols   FROM INFORMATION_SCHEMA.COLUMNS a  left join INFORMATION_SCHEMA.COLUMNS b
 on a.TABLE_name='{$tbl1}' and b.TABLE_NAME='{$tbl2}'
 and a.COLUMN_NAME=b.COLUMN_NAME
WHERE a.TABLE_SCHEMA = '{$get_constant('G5_MYSQL_DB')}' AND a.TABLE_NAME = '{$tbl1}'
union
SELECT a.COLUMN_NAME acols, b.COLUMN_NAME bcols  FROM INFORMATION_SCHEMA.COLUMNS a  right join INFORMATION_SCHEMA.COLUMNS b
 on a.TABLE_name='{$tbl1}' and b.TABLE_NAME='{$tbl2}'
 and a.COLUMN_NAME=b.COLUMN_NAME
WHERE b.TABLE_SCHEMA = '{$get_constant('G5_MYSQL_DB')}' AND b.TABLE_NAME = '{$tbl2}'
";
$result= sql_query( $sql);
$ins_set=array();
$sel_set=array();
echo '<table>';
if( $result) while( $row= sql_fetch_array( $result)) {
        $ins_set[]= $row['acols']?$row['acols']:"''";
        $sel_set[]= $row['bcols']?$row['bcols']:"''";
        echo '<tr><td bgcolor="'.($row['acols']?'':'#d3f9d8').'" >',$row['acols'],'</td><td bgcolor="'.($row['bcols']?'':'#d3f9d8').'" >',$row['bcols'],'</td></tr>';
}
echo '</table>';

echo 'ok';

}