problems getting a script which works locally to work on a remote server

[g0rm4n]

I've got a set of PHP/mySQL scripts for a simple news-posting system which work perfectly on my system. I want to upload them to my webspace (which is PHP/mySQL enabled). The administrator of the space created a database for me. I made sure to replace all of the relevant information in my config.php ($db_host, $db_name, and soforth), so just assume that information is correct.

However, when I tried to use the news script on the site, nothing happens. (remember it works on my system and only the login/access information in the config.php file has been changed - furthermore, PHP is supported for the public_html folder, which is where all my files are located - so something from mysql has to be the issue)

I believe the problem is that there hasn't been a table created in the database (which I did via command line and dumpfile on my localhost test server). How do I go about doing this, or does the system administrator have to do it himself? (all I have is FTP access)

Help would be greatly appreciated. Thanks in advance!

[twopeak]

when you make a query to the database server, ask for the error

mysql_query("SELECT * FROM my_table") or die(mysql_error());

this way you'll see a nice error message if there is an error!

[sijis]

yeah you are going to have to send the administrator the dump file from your local databse so that he can upload that data into your database on his server.
if the administrator is using phpmyadmin it should be a breeze.

i think that the new database on the new server doesn't have any information in it, that's why nothing is showing up. i agree with twopeak do that with your code and will give you a pretty good idea of what's going wrong.

[g0rm4n]

alright, it's definitely the problem.

the error i got was "Table 'otcwebnews.news' doesn't exist"

thanks for the help, i'll let you guys know if/when it's working remotely!