PHP 与MySQL分页显示问题
当我将分页设置为一次显示 10 条评论时,我的评论查询不会将评论回复计入显示计数的一部分,如何修复此问题以便计算我的评论回复?我的评论回复查询嵌套在我的主查询中以显示评论。
分页查询
SELECT COUNT(comment_id) FROM comments WHERE id = $id
显示评论的主要查询。
$dbc = mysqli_query($mysqli,"SELECT comments.*, users.*
FROM comments
LEFT JOIN users
ON comments.user_id = users.user_id
WHERE id = '" . $id . "'
AND parent_comment_id = 0
LIMIT $start, $display");
主要查询回复评论。
//display comments replies
$dbc2 = mysqli_query($mysqli, "SELECT comments.*, users.*
FROM comments
LEFT JOIN users
ON comments.user_id = users.user_id
WHERE id = '" . $id . "'
AND parent_comment_id >= 1");
//display comments replies
$dbc3 = mysqli_query($mysqli, "SELECT comments.*, users.*
FROM comments
LEFT JOIN users
ON comments.user_id = users.user_id
WHERE id = '" . $id . "'
AND parent_comment_id >= 1");
When I set my pagination to display 10 comments at a time my comments query wont count the comments replies as part of the display count how can I fix this so that my comments replies are counted? My comments replies queries are nested in my main query to display comments.
Query for pagination
SELECT COUNT(comment_id) FROM comments WHERE id = $id
The main query to display comments.
$dbc = mysqli_query($mysqli,"SELECT comments.*, users.*
FROM comments
LEFT JOIN users
ON comments.user_id = users.user_id
WHERE id = '" . $id . "'
AND parent_comment_id = 0
LIMIT $start, $display");
The main querys reply comments.
//display comments replies
$dbc2 = mysqli_query($mysqli, "SELECT comments.*, users.*
FROM comments
LEFT JOIN users
ON comments.user_id = users.user_id
WHERE id = '" . $id . "'
AND parent_comment_id >= 1");
//display comments replies
$dbc3 = mysqli_query($mysqli, "SELECT comments.*, users.*
FROM comments
LEFT JOIN users
ON comments.user_id = users.user_id
WHERE id = '" . $id . "'
AND parent_comment_id >= 1");
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
也许这个查询,您能否给出要使用的精确数据库结构。
Maybe this query, could you give the precise DB structure to work with.