参数确实是true,但是还是有警告mysql_fetch_row() expects parameter 1 to be resource?
function checkcanceluserstop($phonenum)
{
$con = mysql_connect(localhost, root, );
if(!$con)
{
echo ;
echo ;
return;
}
$result = mysql_select_db (teleservice,$con);
if(!$result)
{
echo ;
echo ;
return;
}
$result = mysql_query(set names 'gbk');
if(!$result)
{
echo ;
echo ;
return;
}
$query = select state
from phonedetail
where phonedetail.phonenum = $phonenum;
if($result)
{
echo ;
echo ;
} else {
echo ;
echo ;
return;
}
$oldstate = 正常开通;
while($row = mysql_fetch_row($result))
{
echo in while loop...;
$oldstate = $row[0];
echo $oldstate;
}
if($oldstate == 主动停机) {
echo yes;
return true;
} else {
echo no;
return false;
}
mysql_close($con);
}
问题:通过调试,已经可以成功查询到号码的原状态。此时$result = 1;但是后面fetch_row的时候,不能进入到while循环中,出现了警告:warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in h:\wamp\www\frr_canceluserstop.php on line 58
请问:$result = 1确实是1(true)的啊,那为什么进不了循环?
怎么才能取得结果呢?
谢谢各位!
------解决思路----------------------
sql 指令为执行