php mysql插入不进去数据

Question

<?php
session_start();
define ('MYSQL_SERVER','127.0.0.1');//数据库IP
define ('MYSQL_USER','root'); //数据库用户名
define ('MYSQL_PASSWORD','root'); //数据库密码
define ('MYSQL_DATABASE','***********'); //数据库名称
function pConnDB() {

$_link = mysql_connect(MYSQL_SERVER,MYSQL_USER,MYSQL_PASSWORD) or die("连接失败！");
mysql_select_db(MYSQL_DATABASE,$_link);
mysql_query('set names utf8');
return $_link;
}
$u_user = fanSql($_POST['user']);
$u_pass = fanSql($_POST['pass']);
$u_qqqq = fanSql($_POST['qqqq']);
$link = pConnDB();
if($link=="连接失败！")
{
echo '2';die;
}
$sql = 'select * from authme where account = \''.$u_user.'\'';
$qry = mysql_query($sql);
@$ret = mysql_fetch_array($qry);
if($ret==false)
{
$sql = "insert into tablename (xauth,authme) ('$u_user', '$u_pass')";
$qry = mysql_query($sql);
if($qry) {
mysql_close($link);
echo '1';die; //返回成功
} else {
mysql_close($link);
echo '0';die; //返回失败
}
}else{
mysql_close($link);
echo '3';die;
}
}
?>

Answer 1

1.　代码的最后一个 } 没有对应的 {，{}括号不匹配，存在语法上的错误。

2.　sql语法错误，少了个values：

$sql = "insert into tablename(xauth,authme) values('$u_user', '$u_pass')";

Answer 2

看错误日志