cart works locally not at remote server

Finally after much trial and error the store works perfectly on local MAMP server, but files put on remote server I get this error message:

Notice: Undefined variable: database_connNewProRes in /home2/charles4/public_html/store.php on line 43
Notice: Undefined variable: connNewProRes in /home2/charles4/public_html/store.php on line 43
Warning: mysql_select_db() expects parameter 2 to be resource, null given in /home2/charles4/public_html/store.php on line 43
Notice: Undefined variable: connNewProRes in /home2/charles4/public_html/store.php on line 45
Warning: mysql_query() expects parameter 2 to be resource, null given in /home2/charles4/public_html/store.php on line 45


In the store.php file lines 43 and 45 are:

43 - mysql_select_db($database_connNewProRes, $connNewProRes);
44 - $query_rsItems = "SELECT * FROM items WHERE ItemCatID = 1 ORDER BY ItemID ASC";
45 - $rsItems = mysql_query($query_rsItems, $connNewProRes) or die(mysql_error());

What does "mysql_query() expects parameter 2 to be resource, null given" mean??

I used the same files when this worked remotely before (with UPS shipping) the only thing different is the changeover to USPS shipping (which I would think has nothing to do with this issue so early in the process).
I'm also using the same database that I used before...

these errors mean that there is a problem with the connection file and creating the database connection.


usually this happens if you edit the connection file by hand and change the names of the variables that are created by the connection. Did you edit the connection file at all?

Yes, I have to change it because it's different for local and remote. For local I use root and root for username and password, but on remote server it has to be the clients login and password, also for this host I have to add the username to the beginning of the database name. I change it on the server using ControlPanel/File Manager/edit file. I've done it this way before and it never caused me this error...

From your description of the problem, it sounds liker you edited the names of the variables in the connection, not just the values.



for example, if I create a connection named test, the code in my connection file will look like this:

<?php

# FileName="Connection_php_mysql.htm"

# Type="MYSQL"

# HTTP="true"

$hostname_test = "localhost";

$database_test = "test";

$username_test = "root";

$password_test = "rootPW";

$test = mysql_pconnect($hostname_test, $username_test, $password_test) or trigger_error(mysql_error(),E_USER_ERROR); 

?>

when you edit this for the remote server, the variable names must stay the same, only the values of the variables get changed:

<?php

# FileName="Connection_php_mysql.htm"

# Type="MYSQL"

# HTTP="true"

$hostname_test = "remoteServer";

$database_test = "remoteDB";

$username_test = "root";

$password_test = "rootPW";

$test = mysql_pconnect($hostname_test, $username_test, $password_test) or trigger_error(mysql_error(),E_USER_ERROR); 

?>

if you change the variable names, for example:
$hostname_test

it will cause the errors you are describing.

So glad you showed those examples, I got it immediately. I had changed the file name of the connection file, and dreamweaver set it up correctly, but then I had just cut and pasted the content out of the original working connection file. I was blind to the fact that the names on the left side changed also (they are similar, after all...)

original working file that I copied:
$hostname_connProRes = "localhost"; etc.

my new should have been:
$hostname_connNewProRes = "localhost";

Thanks again for the rescue.

you're welcome.