DaniWeb Forum Index > Web Development > PHP

mysq_query on 2 dbs .. ?

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2005

Posts: 2

Reputation: hanpedro is an unknown quantity at this point

Solved Threads: 0

hanpedro

Offline

Newbie Poster

mysq_query on 2 dbs .. ?

Jun 19th, 2005

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 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.

•

Join Date: Jun 2005

Posts: 354

Reputation: Troy is an unknown quantity at this point

Solved Threads: 5

Troy

Offline

Posting Whiz

Re: mysq_query on 2 dbs .. ?

Jun 19th, 2005

Please read and follow Paradox814's post at this thread:
http://www.daniweb.com/techtalkforums/thread25821.html

It will show you some basics of running mysql queries in PHP along with how to read the mysql errors. Use the techniques shown to modify how you run your queries. Create a page that only has the problem--nothing else. Keep the chunk you are working on as small as possible. When you get it working, add one step to it, and test again.

If you run into one step that you can't get working, then post here with just enough information to make your question clear. Most people answering posts don't have time to read entire code modules and debug for you.

Enjoy the journey. [img]dani-images/smilies/fiyellow/icon_smile.gif[/img]

Troy Wolf is the author of SnippetEdit. "Website editing as easy as it gets." IX Web Hosting