为什么 mysql_fetch_array() 存储一个空结果


why does mysql_fetch_array() storing an empty result?

我成功地从数据库表中选择了数据,当我尝试在mysql_fetch_array()的帮助下将数据提取到数组中时,它不会将任何东西存储到数组中。

@session.start();
$name=$_SESSION['umailid'];
$chkname1 = "select * from ".USREG." where email='.$name.'";
echo $chkname1;
// it is printing like this:
// " select * from users_temp where email='.subbu66g@gmail.com.' "
// which means query was successful, above email is there in database table
$res1 = mysql_query($chkname1, $con) or die(mysql_error());
$chkresult1 = mysql_fetch_array($res1);
echo $chresult1['name']; //its not printing anything
if ($chkresult1) //it is storing null and entering into else block
{
    echo "query successful";
}
else {
    echo "query was not successful";
}

结果是"查询不成功"。我认为我的选择查询一切都很好。那为什么这个mysql_fetch_array()不获取数据呢?

$chkname更改为email = $name (删除点)或email = '$name'

并且您正在使用mysql,而不是使用mysqli或pdo sql