mysql update int_mysql update整数型数据问题

<?phpsession_start ();?>StatusEmailFaxStatus

Email

Fax

Tele.num

require_once('config.php');

$conn=mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

if(!$conn) {

die('Failed to connect to server: ' . mysql_error());

}

$db = mysql_select_db(DB_DATABASE);

if(!$db) {

die("Unable to select database");

}

$id=$_SESSION['SESS_ID'];

if($_POST['bthModify']){

$status=trim($_POST['status']);

$em=trim($_POST['email']);

$faxx=$_POST['fax'] as int;

$telenum=$_POST['telenum'] as int;

$sql1="UPDATE user SET status='$status', email='$em',fax='$faxx',tele.num='$telenum' where iduser='$id'";

$result=mysql_query($sql1);

if($result){

echo "modify success";}

else{ echo "Modify fail, Please make sure your information are right.";

}

}

?>

各种存不进 已经更新失败问题出在fax='$faxx',tele.num='$telenum' 因为数据库里这两列是整数型 可后来我把数据库里这两列改成var型仍然失败 只有把这两个值写到其他列才能成功 求解

展开