PHP/MYSQL错误:mysql_num_rows():提供的参数无效 [英] PHP / MYSQL error: mysql_num_rows(): supplied argument is not a valid

问题描述

我有以下代码:

$sql = mysql_query("SELECT id FROM logins WHERE id='" . $this->skID . "'");

if(mysql_num_rows($sql) == 0) { return false; }
else {
      list($skID) = mysql_fetch_row($sql);
      return $skID;
}    

这会带来以下错误.

mysql_num_rows():提供的参数不是有效的MySQL结果 资源

mysql_num_rows(): supplied argument is not a valid MySQL result resource

我已经回显了SQL并在数据库中运行它，但我得到了一个结果，那么问题出在哪里-最欢迎您提出任何想法吗?

I have echoed out the SQL and run this in the database and I get a result, so what the problem - any ideas most welcome?

对不起，我是一个绝对的白痴，试图在ms数据库上使用mysql函数！抱歉！

Sorry Im being an absolute idiot, trying to use mysql functions on an ms database! Sorry!

推荐答案

您已检查是否已建立连接.也许尝试在查询后输出查询结果.还尝试回显您的mysql_error()，看是否有任何问题.

have you checked that your connection has been established. perhaps try outputting the query results after your query. also try to echo your mysql_error() to see if anything went wrong.

echo mysql_error();

查询之后.

这篇关于PHP/MYSQL错误:mysql_num_rows():提供的参数无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！