Update query runs on local server but no on the internet

Question

Please I need some brain storming. I created an update query as seen below.

<?php require_once('Connections/@@@@@.php'); ?>
<?php
$result = mysql_query("UPDATE volunteers, vcodes SET volunteers.sn = vcodes.sn WHERE      volunteers.vid = vcodes.id");
?>    

It runs behind a form within a web application on my local server and produce the right result but when I upload it to the internet, it does not run but just sits there.

Can any one please help ascertain why it runs only on my local server but not on the internet. I am develop my application within Dreamweaver CS6.

Answer 1

1) As others have pointed out, mysql_XXX functions are obsolete. For new code, you should absolutely use the new MySQL APIs: either PDO or mySqli:

• The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

2) Similarly, you should use prepared statements. Not "update..." or "select *". Especially if your server is facing the internet!

• http://www.php.net/manual/en/mysqli.quickstart.prepared-statements.php

3) By default, mySql is configured to allow local connections only. This is a Good Thing. In general, your Web server will face the internet ... but all SQL queries and updates will be local, between your Web Server and MySQL. This is both more secure and more efficient.

3) If you want to use MySQL remotely, you must do two things:

a) Configure a MySQL account to allow remote access

b) Open your server's firewall to the MySQL port

Here is an article that discusses how to do this:

• http://www.rackspace.com/knowledge_center/article/mysql-connect-to-your-database-remotely

Answer 2

One of the reason may be your table and fields names are capitalized. You might be using windows in you local where they are not case sensitive and your remote server might be linux where table and field names are case sensitive. Make sure you are using lowercase letter for your fields and table names.