Find most frequent submitters in your PHPLD powered directory
February 4th, 2006
Now be prepared for a surprise…..
Who occupies or owns your directory? Who is the most frequent submitter?
Here is an sql snippet that will reveal most frequent submitters by their IP address, if run from phpMyAdmin interface:
SELECT IPADDRESS, COUNT( * ) AS “frequency”
FROM PLD_LINK
GROUP BY IPADDRESS
ORDER BY `frequency` DESC
LIMIT 0 , 30
Now that was rather easy, even for such kind of a copy-paste coder as myself, wasn’t it? Similarly you can make queries for most frequently used email address, check duplicate url’s, and more…
