Welcome to WebmasterWorld Guest from 54.204.219.143

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Query Help

     
10:20 pm on May 11, 2007 (gmt 0)

Full Member

10+ Year Member

joined:June 16, 2004
posts:232
votes: 0


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

8:35 am on May 12, 2007 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Nov 26, 2003
posts:1133
votes: 0


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.
Michal

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members