我有一个注释系统;我有一个查询
SELECT ShoutID,Message, User, Date, ShoutImageThumb, ShoutImageBig,UserID,
Email, FullName, UserImageThumb, Admin FROM shoutbox LEFT JOIN users ON
users.Email = shoutbox.User ORDER BY ShoutID DESC LIMIT 10
当它在页面上循环时我在循环中运行另一个查询以获取该消息的注释
SELECT users.UserID, users.Email, users.FullName, shoutboxcomments.ShoutID,
shoutboxcomments.`Comment`, shoutboxcomments.`Date`,
shoutboxcomments.`User`, shoutboxcomments.CommentID FROM shoutboxcomments
LEFT JOIN users ON users.Email = shoutboxcomments.User
WHERE ShoutID = '.$ShoutID.' ORDER BY CommentID ASC
是否可以加入这些查询或我如何简化它,因为IM使用MVC架构在PHP中构建
不要为每个帖子运行一个查询,而是使用 IN
一次获取多个帖子的评论。
SELECT users.UserID, users.Email, ...
FROM shoutboxcomments
LEFT JOIN users
ON users.Email = shoutboxcomments.User
WHERE ShoutID IN (1, 4, 15, 22)
ORDER BY CommentID