| Welcome to WebmasterWorld Guest from 184.108.40.206 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
I am trying to provide users with the sites recent popular list like the digg right column top 10 in all topics. However i am not sure if it is possible to achieve this with one query.
$query_top=mysql_query("SELECT * FROM frontpage ORDER BY post_date, total_votes DESC LIMIT 15, 45") or die(mysql_error());
The query looks at entries that are not on the frontpage and finds the 30 posts after that, however it does not arrange them according to the total votes
yes, it doesn't because you sort first by time, and only then by votes.
The correct one would seem to be:
$sql = "SELECT * FROM frontpage WHERE id NOT IN (SELECT id FROM frontpage ORDER BY post_date LIMIT 30) ORDER BY total_votes DESC LIMIT 15";
I think this should do the trick.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved