php - 用于获取单个值的选择查询不起作用

Question

 $sql = "SELECT temail FROM teacherusers WHERE tfullname='$teachername' limit 1";
 $result = mysql_query($sql);
 $value = mysql_fetch_object($result);
 $teacheremail2 = $value->temail;
 echo $teacheremail2;

echo $teacheremail2什么都不返回。

$teachername是有效的，我已经检查了多次。

标签： phpmysqlsql

Answer 1

结果mysql_fetch_object($result)是一个对象（stdClass）。

object(stdClass)可以在此链接中找到 ic的解释

$sql = "SELECT temail FROM teacherusers WHERE tfullname='$teachername' limit 1";
$result = mysql_query($sql);
while ($value = mysql_fetch_object($result))
    {
    $teacheremail2 = $value->temail;
    echo $teacheremail2;
    }