MYSQL mystery. Value passed to function is incorrect.

Question

When I submit using this function I get an incorrect result for $_REQUEST["add_single"] in the database of 127, incorrect. but the javascript result is 188, correct. If i replace $_REQUEST["add_single"] with 10 I get 10 inserted into the database.

if (isset($_REQUEST["add_single"])) {
    save_single_bracelet($_REQUEST["id"], $_REQUEST["add_single"]);

/javascript alert('values:".$_REQUEST["id"].", ".$_REQUEST["add_single"]."'); /script

;}

For whatever reason I can not get $_REQUEST["add_single"] to pass the correct value to the function.

J.

Answer 1

The column (bracelet_id) wouldn't happen to be of type TINYINT? The maximum value of that data type is 127. You should change it to something more appropiate like INT.

You can view more about data types in MySQL here