php - Pre mysql 输出与 Phpmyadmin 中处理的更新不同

Question

$newInt = substr_replace($oldInt, $newDigit, $position, 1);
             $newValue = (string)$newInt;
            echo $newValue;

echo 00001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 (我想要什么!)

mysql_query("UPDATE table SET $fieldVariable = $newValue WHERE userID  = '".$_SESSION['userID']."' ")or die("Query failed:".mysql_error());

mysql记录显示999999999999999999999999999999999999999999999999999

mysql字段设置为varchar(100)

Answer 1

在 $newValue 周围添加引号，因为它是 VARCHAR 字段

mysql_query("UPDATE table SET $fieldVariable = '$newValue' WHERE userID  = '".$_SESSION['userID']."' ")or die("Query failed:".mysql_error());