|
Okay well I am just giving you ideas here we dont support code hacking. Try this as this is what I told you to do.
$query = "SELECT id,user,userid,cat,storecat,title,bigimage,views,height,width FROM {$Globals['pp_db_prefix']}photos WHERE approved='1' AND storecat='0' AND date > UNIX_TIMESTAMP( DATE_SUB(NOW(), INTERVAL 14 DAY) ) ORDER BY views DESC LIMIT $grabnum";
|