Posted by Shelly on 08/17/07 15:13

Here is a crazy question that has happend to me once before.

I have an include file for the connection information to the server. It is
like this:

$hostname= "the_server_location";
$database = "the_database_name";
$dbUsername = "the_username";
$dbPassword = "the_password";
$dbCon = mysql_pconnect($hostname, $dbUsername, $dbPassword) or
die(mysql_error());
mysql_select_db($database, $dbCon);

In my main file I have right near the top:

require_once("dbLogin.php");

I then have lines in a function where I pass in $sbCon as $con (The quotes
are single-double for the fist one and double-single-double for the second
one):

$q = "SELECT * FROM Company WHERE accountNumber='" . $num . "'";
$res = mysql_query($q, $con) or die(mysql_error());

This gives me an invalid resource at the mysql_query line.

HOWEVER, If I comment out the require_once line and copy and paste the code
for it directly into the calling module, it works fine. Note that this was
a strict cut and paste and the only keyboard strokes that I did were the the
slashes to comment out the require_once.

Does anyone have any ideas?

Shelly

• Next in forum: Re: Two MySQL servers, one script
• Prev in forum: Need help sorting a XML file
• Thread view: Problem with require_once

[Reply to this message]