Can anyone help me with this code
Code: Select all
my $gen_ip = $db->SelectARef("SELECT INET_NTOA(ip) as ip_txt, SUM(money) as money, COUNT(*) as downloads
FROM IP2Files
WHERE created>NOW()-INTERVAL 48 HOUR
GROUP BY ip
ORDER BY money DESC
LIMIT 20");