Question

PHP 更新数据为什么没反应?

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
include_once 'mysql_str.php';
$link = mysql_connect("localhost","root","0000");
mysql_select_db("wow",$link);
$id = $_POST['uid2'];
$usern = $_POST['usname2'];
$pwd = $_POST['pwd2'];
$sql="update wow_user set user_name = $usern,pass_word = $pwd where id= $id";
if (mysql_query($sql)) echo "SQL执行成功！";
echo "帐号";
echo $usern;
echo "<br/>";
echo "<br/>";
echo "密码";
echo $pwd;
echo "<br/>";
echo "<br/>";
echo $id;
echo "<br/>";
echo "<br/>";
echo $sql;
?>

帐号 密码 ID 都有值 也能能 用echo输出来 修改不了数据 ?

Answer 1

$sql="update wow_user set user_name = $usern,pass_word = $pwd where id= $id";

改成
$sql = "update wow_user set user_name='".$usern."',pass_word=$pwd where id=$id";