Mysqli查询工作在phpmyadmin，但不是在脚本

Mysqli query working in phpmyadmin but not on script

本文关键字：脚本 phpmyadmin 查询工作 Mysqli | 更新日期: 2023-09-27

我的mysql查询是SELECT匹配phpMyAdmin(119行)查询的所有行，但只选择少数(6行)，当涉及到php脚本。下面是我的phpMyAdmin代码:

SELECT * FROM  Query WHERE status=0 && category!='edu' ORDER BY qtime ASC

$sql= mysqli_query($con,"SELECT * FROM  Query 
        WHERE status=0 && category!='edu' ORDER BY qtime ASC");
echo mysqli_num_rows($sql); //which is giving 6 always

所以，显然连接是好的&运行查询时没有错误。现在，我不知道到底是哪里出了问题。谢谢你的帮助!

`SELECT * FROM  Query WHERE status IN(0) AND category!='edu' ORDER BY qtime ASC;`