쿼리 데이타가 form 문에서 안보이네요?
아래 소스에서 form에서 리스트로 나와야 하는데...
<?
$db1[host] = "localhost";
$db1[user] = "abc";
$db1[pass] = "1234";
$db1[db] = "db1";
$db1[dir] = "a/ab";
$db2[host] = "localhost";
$db2[user] = "abc";
$db2[pass] = "1234";
$db2[db] = "db2";
$db2[dir] = "a/cd";
$db1[link] = @mysql_connect($db1[host], $db1[user], $db1[pass])
or die("host, user, pass 오류.");
@mysql_select_db($db1[db], $db1[link]) or die("$db1[db]
접속불가.");
$db2[link] = @mysql_connect($db2[host], $db2[user], $db2[pass]) or
die("host, user, pass 오류.");
@mysql_select_db($db2[db], $db2[link]) or die("$db2[db]
접속불가.");
?>
<HTML>
<HEAD>
<TITLE>CONVERTER</TITLE>
<script>
function in_check() {
if (form1.delete_chk.checked) form1.delete_flg.value=1 ;
if(!document.form1.my_id.value) {
alert("INPUT THE apps ID !!!");
document.form1.my_id.focus();
return false;
}
if(!document.form1.my_id.value) {
alert("INPUT THE myapps ID !!!");
document.form1.my_id.focus();
return false;
}
return true;
}
</script>
</HEAD>
<BODY>
<table align= center border=0 width=500 cellspacing=0
cellpadding=0 >
<form name=form1 action="my2db2.php" method="post"
onsubmit="return in_check();">
<tr>
<td align=center><span style="font:32 impact;
color:#CDB8CD"
>Return</span><br><br></td>
</tr>
<tr>
<td>
<table width=100% >
<tr>
<td align=left>my apps</td>
<td align=left>db2 apps</td>
<td></td>
</tr>
<tr>
<!--<td><input type=text name=my_id
style="width:100%;"></td>-->
<td align=left>
<select name="my_id" >
<?
$db1[dataz]='SELECT no,name FROM control_table order by
no';
$result_db1=mysql_query($db1[dataz]);
while($data=mysql_fetch_array($result_db1)) {
?>
<option value=<?=$data[name]?> >
<?=$data[name]?> </option>";
<?
}
?>
</select>
</td>
<td align=left>
<select name="my_id" >
<?
$db2[dataz]='select rpt_num,rpt_id,rpt_name from gb_apps order by
rpt_num';
$result_db2=mysql_query($db2[dataz]);
while($data=mysql_fetch_array($result_db2)) {
?>
<option value=<?=$data[rpt_id]?>
><?=$data[rpt_name]?> </option>";
<?
}
?>
</select>
</td>
아시는 분은 좀 가르쳐 주세요
|