Jaguar Posted June 22, 2007 Share Posted June 22, 2007 I need to do soemthing like this. SELECT * FROM topics ORDER BY replies/date LIMIT 10; I want to get the top 10 "popular" topics from my forums. I define popular as the total number of replies divided by time elapsed since the topic was created. ---topics--- date (date) (date topic was posted) replies (mediumint) (total number of replies) ------------ Will I have to do math in PHP to get the number of days (or minutes or seconds) passed since the date? That could get bad if I actually ever get a lot of forums. Link to comment https://forums.phpfreaks.com/topic/56788-solved-select-popular-topics-only/ Share on other sites More sharing options...
bubblegum.anarchy Posted June 22, 2007 Share Posted June 22, 2007 math is what computers do best. Link to comment https://forums.phpfreaks.com/topic/56788-solved-select-popular-topics-only/#findComment-280540 Share on other sites More sharing options...
bubblegum.anarchy Posted June 22, 2007 Share Posted June 22, 2007 SELECT * FROM topics ORDER BY replies / timestampdiff(SECOND, date, CURRENT_TIMESTAMP) timestampdiff >= mysql.version() v5.0.0 Link to comment https://forums.phpfreaks.com/topic/56788-solved-select-popular-topics-only/#findComment-280544 Share on other sites More sharing options...
Jaguar Posted June 22, 2007 Author Share Posted June 22, 2007 Thank you very much! Exactly what I was looking for <3 If I did it in PHP the array could get huge. Link to comment https://forums.phpfreaks.com/topic/56788-solved-select-popular-topics-only/#findComment-280554 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.