Welcome to WebmasterWorld Guest from 54.145.209.34

Forum Moderators: coopster & jatar k

Query Help

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

10+ Year 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

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

WebmasterWorld Senior Member 10+ Year Member



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

 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month