2 things..
how do i query say.. the newest 10 items..
and.. i know how to query say the first 10 items in a field, but how do query say the last 10?
$connection = mysql_pconnect(SQL_SERVER, SQL_UID, SQL_PWD);
mysql_select_db("vote", $connection);
$reportops = Array("voteavg", "votecount", "sex", "bonks");
$reports = Array("Best Results", "Most Votes", "Top Sex", "Most Reported");
$reportsql = Array(
"select from user where blocked=0 order by active desc, voteaverage desc, votecount desc limit 10",
"select from user where blocked=0 order by active desc, votecount desc limit 10",
"select from user where blocked=0 order by active desc, sex, voteaverage desc, votecount desc limit 10",
"select from user where blocked=0 order by active desc, bonks desc limit 10");
thats what i got right now.. its got basically the top 10, i also want the bottom 10, and also a thing for like the 10 newest.. thanks.. the page is here.. http://www.abda53.com/vote and click on Top 10
