为什么即使 $result 返回空结果集 mysql_num_rows($result) 也返回 1? [英] Why does mysql_num_rows($result) return 1 even if $result returns empty result set?

问题描述

为什么即使$result返回空结果集，mysql_num_rows($result)也返回1?

$resut=mysql_query("select * from tablename where column1='$memberid' and (TIME_TO_SEC(TIMEDIFF(NOW(),when_submit))/60<2)")or die(mysql_error());$count=mysql_num_rows($result);

当我 echo $count 时，我得到 <块引用>

1

.

解决方案

您的代码中有拼写错误.您将调用 mysql_query() 的结果存储在名为 $resut 的变量中.那应该是 $result，因为这是您在调用 mysql_num_rows()

时传递的内容

Why does mysql_num_rows($result) return 1 even if $result returns empty result set?

$resut=mysql_query("select * from tablename where column1='$memberid' and (TIME_TO_SEC(TIMEDIFF(NOW(),when_submit))/60<2)")or die(mysql_error());
$count=mysql_num_rows($result);

when I echo $count, I get

1

.

解决方案

You have a spelling error in your code. You store the result of the call to mysql_query() in the variable called $resut. That should be $result, since that is what you are passing in the call to mysql_num_rows()

这篇关于为什么即使 $result 返回空结果集 mysql_num_rows($result) 也返回 1?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！