Works on WAMP but not on remote server

[waydown]

Hi,
I have WAMP (PHP Version 5.5.12) running on my machine. My program works on WAMP but when I run program on remote server (PHP Version 5.4.32) I get following error:

Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'address' in 'field list' )

I am trying to transfer details from a form to a database. I don't know if the problem is related to following input on form:

Address:<br> <textarea name="address" rows="3" cols="25" WRAP="hard"><?php echo escape(Input::get('address')); ?> </textarea>

Input::get($item) returns $_POST[$item] if it is set. Other entries are like:

Last name: <input type="text" name="last_name" value="<?php echo escape(Input::get('last_name')); ?>">

and do not create problems. I have tried using print_r($e->errorInfo()); in my catch statement:

catch(Exception $e)
       { die($e->getMessage());
       }

but that doesn't work. I don't know if I am using it correctly or not. Could someone offer a suggestion. I would be very grateful.

 

[jpadie]

that suggests that there is no field called 'address' in the database table.

 

[spamjim]

You may have a column named "Address" instead of "address".

By default, Windows' MySQL (in WAMP) is not case sensitive. Your production server probably is.