Server issues

loureiro

ok, my code works fine on my computer but when i upload it to the server i get an error on one of my pages. its a problem creating a connection i think...here is the error message i get:

Warning: mysql_query(): 11 is not a valid MySQL-Link resource in /usr/local/psa/home/vhosts/clubcranberry.com/httpdocs/demo/editCustomer.php on line 35
editCustomer.php|SQL address query error:

mysql_query( $sqlAddress, $connection ) or die( "editCustomer.php|SQL address query error: ".mysql_error() );

is there a setting i can change to correct this?

please help!

LordShryku

It's saying your connection is invalid. Make sure it actually connects, you're picking the right database, and you don't close it before querying.

loureiro

the exact same code works fine on my own computer. i have it set up as a server...just a simple one but it doesnt work on a dedicated server. possibly the settings?

LordShryku

Possibly. Are the server name and database the same name on the dedicated server? Have you set error_reporting(0) and used mysql_error to get more detailed error descriptions?

loureiro

im pretty sure it has something to do with the connection and possibly a setting that wont allow me to make a connection in that case but...

gufmn

How did you upload the db? I have run into situations where I create a db through phpmyadmin/siteworx and it appends part of my username to the db name. Like, if uname = gufmn and db name is products, it ends up calling it gufmn_products and I have to change the connection properties in the script.

Just a thought.

loureiro

i know it has nothing to do with the name of the database because i have already inserted a record into it and i use a config file to grab the names and passwords ect...

i also know it isnt anything with the code because it works fine on my computer but not on the server! im pretty sure its a setting and i was wondering if you could point me in that direction.