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 ... 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? 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 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 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
Archived
This topic is now archived and is closed to further replies.