Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

mbautiger

Hello,

My first post to this board, as I am trying to learn PHP/MYSQL. I realize this is a PHP forum but I figure most of you must have experience in MYSQL.
Anyway, I have a site setup where I actually have two domain names running off of one server and one database on that server...or so I desire. The first site is working fine and pulling from the database like a champ, however the second site is not pulling from the database at all. To create the second site I simply copied all the code over to a second directory on the server and made a few changes accordingly like the global parameters I use $full_path_to_site and $URL now equal that of the new site and new directory structure. I can access the second site fine, however when I go to a page that is dynamically built from the mysql database I get an error such as "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www....[rest of path]".
I think this means the site is not connecting to the database...right? I have the same db.inc.php that I include on everypage for connection purposes. In the file I have the 'localhost' and other connection info. The first site uses this file fine and connects. Why can't the second site connect? Any ideas?
Thanks in advance.
Mike

siwis

Well, as you know that your coding works on one domain, you've got to work out which portion of that code makes the second domain choke.

Create a new php file within the second domain.
Include the globals as per the rest of your scripts.
Perform a db connect and a simple query, adding various error reports for failures along the way.
Once you know whether the connection is actually being made correctly you can move on.
The error gives a clue that the query is not being performed.

mbautiger

Good idea about the test. I created a very basic page using the short code below (taken from mysql documentation) and it works fine. The only difference between this code and my code that is not working is that I have a db include file that has the connect info. In each php file I include this db file. I know the info in that file is correct, but maybe my code is not finding that include file...
I'll keep working on it. Thanks
<?

include_once("admin/config/general.inc.php");
include_once("admin/config/options.inc.php");
include_once("admin/config/globalad.inc.php");
include_once("admin/config/globaluser.inc.php");

<HTML>
<HEAD>
<TITLE> Our List of properties </TITLE>
<HEAD>
<BODY>
<?php // Connect to the database server
$dbcnx = @mysql_connect("localhost",
"user", "password");
if (!$dbcnx) {
echo( "Unable to connect to the " .
"database server at this time." );
exit();
} // Select the jokes database
if (! @mysql_select_db("scenicrentals") ) {
echo( "Unable to locate the joke " .
"database at this time." );
exit();
} ?>
 Here are properties in our database: 
<BLOCKQUOTE> <?php

// Request the text of all the jokes
$result = mysql_query(
"SELECT sitedescription FROM ad where siteid = 5");
if (!$result) {
echo("Error performing query: " .
mysql_error() . "");
exit();
} // Display the text of each joke in a paragraph
while ( $row = mysql_fetch_array($result) ) {
echo("" . $row["sitedescription"] . "");
} ?> </BLOCKQUOTE>
</BODY>
</HTML>

jerdo

Have you tried changing the connect info from localhost to the name of the server? If the DB was setup on the first domain then the second domain should have to point at that domain.

siwis

You might also consider echo'ing one variable value from each of the included files to see whether those includes are actually being read.

mbautiger

Well I change my test script to now use the include file. I then got the "database cannot connect" error exception. I then echo'd back the database/username/and host name info in my test script to make sure it was picking up the correct info from the db include file...sure enough it echo's back the correct login info, and then the next line has the error exception "cannot connect to database. It's just odd that I can connect to the database if I harcode in the connect information in the test script. Still trying to figure out the issue. I appreciate you all responding. 🙂 It keeps me thinking and talking it out, which sometimes helps as well.
thanks