Is it possible to display results from more than one database in one single
page? I have a page that displays results from two tables in a single page and
it was working fine. But when I added a table from another database, (although
it doesnt give a connection error) it does not display the results from that
other database's table. And I am getting the following error, although the same
line was working in the first database's tables.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in /home/content/.......php on line 17
and here is that line 17:
while ($row = mysql_fetch_array($query))
for reference here is the whole program - this was working fine for the first
database tables:
<?php
//Connect To Database
$hostname='....';
$username='....';
$password='....';
$dbname='....';
$usertable='birds';
mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to
database! Please try again later.');
mysql_select_db($dbname);
$query=mysql_query("select * from birds");
while ($row = mysql_fetch_array($query)) {
echo"<br/><p class='newstitle1'> bbbb1: " . $row['newsid'] . "<br/> coltitle1:
" . $row['id'] .
"<br/> <p id=newstext1>pppp1: " . $row['name'] ;}
?>
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
[Non-text portions of this message have been removed]
