我正在创建一个页面,查询表中所有结果的所有列,这些列按入口时间按降序排列 . 当我查询行的计数时,查询工作正常,但当我尝试再次查询表中的数据时,我什么也得不到 . 我决定尝试将查询减少到 "SELECT * FROM comments"
,但是 "SELECT COUNT(*) AS count FROM comments"
之前我仍然没有得到任何结果 . 我've tried using mysqli_error(), but that didn' t给我任何信息 .
查询似乎没有失败,因为mysqli_query()的结果不是false,当我在phpMyAdmin中查询时,查询起作用 . 下面是我的一小段代码
//open databases
require_once($root . "databases/data.php");
//get number of suggestions in comments table
$cquery = mysqli_query($cbase, "SELECT COUNT(*) AS count FROM comments"); //this works
$c = mysqli_fetch_array($cquery);
$count = $c["count"];
//get all suggestions
//this query fails
$queryText = "SELECT * FROM comments ORDER BY time DESC LIMIT " . (($page - 1) * $pageLimit) . ", " . $pageLimit;
$query = mysqli_query($cbase, $queryText);
//validate query
if($query === false)
{
$failed = true;
}
//get all comments from query
while(!$failed && $array = mysqli_fetch_array($result))
2 回答
请在第3行试试
你也可以尝试这样,
在while循环中读取查询结果时,您只是使用了错误的变量 .
mysqli_fetch_array($result)
在$ query中保存了查询结果,所以它应该是mysqli_fetch_array($query)