Question

Is there a tried and true best practice for displaying most viewed posts? Do people normally set up a viewed table and count records? I believe this would require a join of the posts and viewed table when retrieving data. Is there a better way? Thanks.

Answer 1

也许会设立一个<代码>views的表格,有独一无二的贴现、贴现和IP地址/unique识别符号。这样,你们就可以以所有观点/观点来看待。

页: 1

SELECT [...], COUNT(DISTINCT(views.ip)) count
FROM posts
INNER JOIN views ON views.postid = post.id
ORDER BY count DESC
GROUP BY post.id

Answer 2

You can create a field called (visited) and touch it everytime someone open the page (set visited=visited+1) So you can order by visited.

我希望它能够提供帮助。

友情链接