Archive for February, 2004

MySql Case Insensitive Order_by

2
responses
by
on
February 4th, 2004
in
Cool Scripts

While answering a question in the wordpress forums, I remembered an (obscure to me) function in php which generates a regular expressions ( regex ) to be used in a MySql query. This is very useful when performing a dynamic ORDER_BY or a SELECT and you do not want to use the LIKE statement. The syntax is as follows: $new_string = mysql_regcase($string); Where the $string was the original query string and the $new_string is the regex for that query string. I am not sure whether WordPress uses this or not. However, it sure could prove useful in unlikely circumstances.

[Continue Reading...]

WordPress CSS Styles, Themes, Templates galore!

No
responses

The CSS styles competition at Alex King‘s website is really heating up. There are some really wonderful examples of these themes on display and there is more to come! If you are looking for a nice theme to start with or for some design ideas, this is definitely worth a check out. If I was not that busy this semester, I would have worked on something (though my work does not validate most of the time). Thank the authors and please provide attribution if you use their work.

[Continue Reading...]

Blog Statistics

5
responses

My crawler has unearthed dissappointing results. Here are the most recent stats: total blogs crawled: 49807 total wordpress blogs: 193 total Blogger blogs: 13587 total Typepad blogs: 1358 total .Text blogs: 269 total BlogTool 1.4 blogs: 226 I was really hoping to find more blogs that are run by WordPress. I have a sneaking suspicion that a lot of WordPress blogs do not have the original meta tags from the index and are thus not responding the way they should. In order to circumvent this problem, I would really like to solicit some help from my readers. If you are a blogger and your blog is using the WordPress application (any version) please click on this link, type in the url of your blog and click on submit. If your blog urls is already in the database, it will make sure that it is recognized as a WordPress blog and […]

[Continue Reading...]

Count Number of WordPress blogs

1
response
by
on
February 1st, 2004
in
General

I wrote a little crawler which counts the number of WordPress blogs (among others such as blogger, .Text, BlogTool etc) that ping weblogs.com and Blogrolling.com recently updated list. Here is the link to the most updated stats. The crawler has just been running for a day and if your site is not in the list, please be patient and it will get listed in time. The crawler code is being tested and modified and the database might get emptied from time to time for code changes. However, it looks good for now and is a very good place to advertise the variety of sites that WordPress can handle. I am planning to add an XFN crawler when I get the chance. I will make the database available publicly (after you promise to NOT use it for nefarious purposes) once it reaches a 100,000 entries. Please let me know what you […]

[Continue Reading...]



Obviously Powered by WordPress. © 2003-2013

css.php