| Query Help
|
BlackRaven
msg:3337508 | 10:20 pm on May 11, 2007 (gmt 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
|
mcibor
msg:3337924 | 8:35 am on May 12, 2007 (gmt 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
|
|
|
