March 8th, 2006, 08:00 PM
|
#6 (permalink)
|
| Member Verified Customer
Join Date: Dec 2004 Location: techarena.in
Posts: 421
|
I tried to change Quote:
// Lets get the Top Posters
$queryz = ppmysql_query("SELECT user,userid,COUNT(*) AS pcount FROM {$Globals['pp_db_prefix']}photos GROUP BY user ORDER BY pcount DESC LIMIT
| to Quote:
// Lets get the Top Posters
$queryz = ppmysql_query("SELECT user,userid,COUNT(*) AS pcount FROM {$Globals['pp_db_prefix']}photos GROUP BY user ORDER BY pcount AND date > UNIX_TIMESTAMP( DATE_SUB(NOW(), INTERVAL 1 MONTH) ) DESC LIMIT
| but this wont work.
cannot find toprated query..
|
|  |