greenyeyes26 Posted August 8, 2007 Share Posted August 8, 2007 Hi there i have a problem building a site with news table news news_id, news_title, news_date, news_category now, i want to present the 5 most popular articles based on clicks (views) of every article in a place of the main page. The page that displays the articles is e.g. article.php?news_id=453 Also, i need to find a solution to present the 5 most related articles to the one is viewed. Please ... urgent need for help ... Quote Link to comment https://forums.phpfreaks.com/topic/63941-query-for-most-popularrelated-articles/ Share on other sites More sharing options...
frost Posted August 8, 2007 Share Posted August 8, 2007 Are you recording the clicks? If so you could just select the ones with the highest clicks from the database? Quote Link to comment https://forums.phpfreaks.com/topic/63941-query-for-most-popularrelated-articles/#findComment-318726 Share on other sites More sharing options...
greenyeyes26 Posted August 8, 2007 Author Share Posted August 8, 2007 Unfortunatelly my friend i don't know the way to record the clicks. Any help would be greatly appreciated Quote Link to comment https://forums.phpfreaks.com/topic/63941-query-for-most-popularrelated-articles/#findComment-318730 Share on other sites More sharing options...
eZe616 Posted August 8, 2007 Share Posted August 8, 2007 I would creat a field for # of clicks, and add +1 to the current value in the field. Other than that I don't know. Just a thought though Quote Link to comment https://forums.phpfreaks.com/topic/63941-query-for-most-popularrelated-articles/#findComment-318835 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.