php - MySQL - 显示计数结果

Question

我只是想展示 MySQL (PHP) 中的咨询结果。代码是:

$example = mysql_query("SELECT count(*) as text FROM table WHERE name = '$name'");
$qtd = mysql_num_rows($example);
while($data = mysql_fetch_array($qtd)){
$count = $data["text"];
}

echo "<h3>($count)</h3>";

Error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\Site\index.php on line 9

Answer 1

改变这个

 while($data = mysql_fetch_array($qtd)){
 $count = $data["text"];
 }

至

while($data = mysql_fetch_array($example)){
 $count = $data["text"];
  }

编辑:您不需要在这里执行 while 循环。

你应该这样做

     $example = mysql_query("SELECT count(*) as text FROM table WHERE name = '$name'");
     $data = mysql_fetch_array($example) ;
     $count = $data["text"];
     echo "<h3>".$count."</h3>";