princeads Posted March 9, 2008 Share Posted March 9, 2008 Hiya, Just got a problem with my sql statement that links my PHP to MYSQL database. My sql statement is below but I'm unsure how to change the statement to only retrieve the top 5 news results based upon this calculation: Number of hits (cmsnews.hits) divided by the number of days since created date (cmsnews.date). $sql = "SELECT cmsnews.newsID, cmsnews.title, cmsnews.article, cmsnews.status, cmsnews.date, cmsnews.hits, cmscontentstatus.statusID FROM cmsnews, cmscontentstatus WHERE cmsnews.status = cmscontentstatus.statusID AND cmscontentstatus.status = 'Published' ORDER BY cmsnews.hits DESC LIMIT 0, 5 "; Any help would be great, cheers AB Quote Link to comment Share on other sites More sharing options...
princeads Posted March 10, 2008 Author Share Posted March 10, 2008 Anyone got any ideas?? Sorry to post again, but stuck for ideas where to start. Cheers AB Quote Link to comment Share on other sites More sharing options...
fenway Posted March 10, 2008 Share Posted March 10, 2008 There's a DATEDIFF() function. Quote Link to comment 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.