$time = time() - 15 * 60;
$result = mysql_query("SELECT * FROM user_online where `ctime` > '$time' and uid in (select uid from user_tag where tag_id in (select tag_id from tag where `tag_name`='$skill')) order by rand() limit 1");while($row = mysql_fetch_array($result))
{
echo "<script language=\"javascript\">alert(\"success!\");</script>";
}数据库查询代码在PHPMYADMIN里面试过了,没有错误,但是总是在运行到while($row = mysql_fetch_array($result))的时候出现错误mysql_fetch_array(): supplied argument is not a valid MySQL result resource
因为传入值是中文,mysql_query("set names 'gbk'");也设定在连接代码下了,不知道错误在哪,求教
$result = mysql_query("SELECT * FROM user_online where `ctime` > '$time' and uid in (select uid from user_tag where tag_id in (select tag_id from tag where `tag_name`='$skill')) order by rand() limit 1");while($row = mysql_fetch_array($result))
{
echo "<script language=\"javascript\">alert(\"success!\");</script>";
}数据库查询代码在PHPMYADMIN里面试过了,没有错误,但是总是在运行到while($row = mysql_fetch_array($result))的时候出现错误mysql_fetch_array(): supplied argument is not a valid MySQL result resource
因为传入值是中文,mysql_query("set names 'gbk'");也设定在连接代码下了,不知道错误在哪,求教
用错函数了。
为啥没有传入呢?
$skill = isset($_POST['skill'])?trim($_POST['skill']) : ' ';