Update statement data doesn't go into db

//setting veriables
$imagestring = $_FILES["file"]["name"];
$myuser = $_POST['myusername'];
//mysql set up error handle
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$chkuserid = mysql_query("select UserID from users where Username = '".$myuser."'"); 
$row = mysql_fetch_array($chkuserid); 
$finall = $row['UserID']; 
  // putting data into database
var_dump($finall);
$sql="UPDATE users SET avatarstring='k00138899.atspace.eu/photoalbum/upload/".$imagestring."' WHERE UserID='".$finall."'";

我想我在用户表中尝试了一切，我有avatarstring，如果上传成功，它将存储图像路径

userid - int(25)
$finall - string
avatarstring - TEXT
文件被上传，但图像地址的入口应该去avatarstring列随着这个操作。


上传图片的代码可以工作，这段代码放在if语句中，如果上传成功，这段代码将与消息一起显示:图片上传成功

    else
      {
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "avatar/" . $_FILES["file"]["name"]);
      echo "Stored in: " . "avatar/" . $_FILES["file"]["name"];
        // if upload successful add entry into DB
$host="fdb4.atspace.com:3306"; // Host name
$username="1259829_photo"; // Mysql username
$password="j8"; // Mysql password
$db_name="1259829_photo"; // Database name
$tbl_name="users"; // Table name
//setting veriables
$imagestring = $_FILES["file"]["name"];
$myuser = $_POST['myusername'];
//mysql set up error handle
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$chkuserid = mysql_query("select UserID from users where Username = '".$myuser."'"); 
$row = mysql_fetch_array($chkuserid); 
$finall = $row['UserID']; 
  // putting data into database
var_dump($finall);
var_dump($myuser);
$sql="UPDATE users SET avatarstring='k00138899.atspace.eu/photoalbum/upload/".$imagestring."' WHERE Username='".$myuser."'";

      }
    }
  }
else
  {
  echo "Invalid file";
  }
?>