我的 MYSQL 语句有问题
警告:mysqli_num_rows() 期望参数 1 为 mysqli_result,bool 在 C:\Users\RBLara\Documents\My Projects\focalnews\index.php 第 188 行中给出
$sqltype = "SELECT * FROM focalnews_items ORDER BY datime ASC limit $last,20 WHERE (likes >= 5 OR love >= 5 OR informative >= 5)";
$resulttype = mysqli_query($conn, $sqltype);
if (mysqli_num_rows($resulttype) > 0) {
while($row = mysqli_fetch_assoc($resulttype))
{
$profile_pic = $row["profile_pic"];
$author = $row["author"];
$message = $row["message"];
$likes = $row["likes"];
$love = $row["love"];
$informative = $row["informative"];
$datime = $row["datime"];
$joined_date = $row["joined_date"];
}
}
?>
请问有什么想法吗?
ORDER BY 和 LIMIT 应该放在最后。
您可以使用多个条件OR
如下
WHERE likes >= 5 OR love >= 5 OR informative >= 5
您的查询应该是
$sqltype = "SELECT * FROM focalnews_items WHERE likes >= 5 OR love >= 5 OR informative >= 5 ORDER BY datime ASC limit $last,20";
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句