I have a problem on mysql_query on using 2 dbs on 1 mysql server.
Please help, and code is;;
<?
$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";
$db[link] = @mysql_connect($db1[host], $db1[user], $db1[pass]) or die("host, user, pass .");
?>
<HTML>
<HEAD>
<TITLE>test</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]);
$result_db1 = mysql_result(mysql_query("SELECT no,name FROM db1.control_table WHERE 1 LIMIT 1"), 0, 0); // databaseA.tableA.fieldA SELECT!
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>
I could not see any datas.