Niche Switch

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…

This blog shall serve as an additional resource at NicheSwitch, mainly to manage articles about directories and other topics of interest. I’m not much of a blogger, at least not a regular one, and my English is, quite frankly, a bit insufficient for witty posts with some twist, so I will have to resort to some semi-regular updating only, and to short down-to-earth posts instead of long philosophical analysis.

The switch got pressed, at least on this blog, with whole site still being in a kind of beta version. First articles on directories will be posted soon.