I think the problem is in your first database, the table is registered, and in
another database, the table that you want to manipulated is not registered.
So, You must change the $dbname in mysql_select_db function to your db that do
you want to manipulated.
correct me if i'm wrong.
Tedit kap <[EMAIL PROTECTED]> wrote: 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]
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
[Non-text portions of this message have been removed]
