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…

Share and Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.
  • digg
  • del.icio.us
  • YahooMyWeb
  • Reddit
Posted by Tomas Filed in directories, code

2 Responses to “Find most frequent submitters in your PHPLD powered directory”

  1. Jim Westergren Says:
    February 5th, 2006 at 8:34 pm

    Thanks a lot!

    I will use it one day. Will be interesting with mine almost 8K big listings.

    / Jim

  2. Tomas Says:
    February 5th, 2006 at 9:34 pm

    Hi Jim, you are welcome. I hope to post something more advanced in that respect, that was just a short thing while playing with the blog :) .

Leave a Reply