Query not submitting right data?

[bike5]

I have:

} elseif($arcade!="ON") {
$location = substr($colum[user_shortcut],2,32);
$zero = "00";
$add = $zero . "" . $location;
echo"$add";
$query = "UPDATE $TableName SET user_shortcut='$add' WHERE user_session='$user_islogged' LIMIT 1";
mysql_query($query) or die(mysql_error());
require("user_connect.php");
echo"$col[user_shortcut]";

I echo $add and it displays the right information of 0000000000000000000000000000000000
, but, that does not update into the table, the old value is still in their.
$col[user_shortcut] equals 0100000000000000000000000000000000 , which is what is updated when the checkbox is clicked to ON. But when they click it off, it doesn;t update the ALL 0's. Yet, I echo what its suppsoed to update and it says all 0's. Anyone have an idea why?

Thanks for the help in advance.

Danny

[bike5]

The $col I typed is really $colum in the code, so don't think thats an error. And yes I know its spelled wrong, but I got used to it that way and its just easier.

[sarahk]

I'd check out user_session='$user_islogged' first by echo'ing out the whole $query and seeing what that looks like. Often you can't see the problem until you see the whole statement spelt out on the browser. Even then you sometimes have to copy & paste into mysql for the message to get across.

[bike5]

Thanks for the suggestion, but that was correct. Good news is I found out how to get it to work. I had to require the user_connect.php page in the else, The user_connect page is allready required within a bigger IF statment so I don't know why it would need it again, but I added it and now it works so Im all set. Thanks again.