Posted on: August 16, 2010 by Chris Coyier
I’m all about tinkering with different ideas to display posts with WordPress. After all, it’s just a bunch of data at our fingertips! WordPress makes it easy to output whatever we need. Not long ago we experimented with making a Thumbnail Based Archives. Now let’s build a Randomized Grid Archives.

Keep Reading
Posted on: August 9, 2010 by Jeff Starr
Here are some sweet SQL code snippets for easy comment management. Sometimes it’s easier to modify comment status and delete unwanted comments on a sitewide basis. Using a program like phpMyAdmin makes it so easy to do stuff like remove spam, close/open comments on old posts, enable/disable pingbacks for specific time periods, and so on. Just remember to backup your database before running any queries.
Remove all spam comments from the database
This SQL query removes all comments marked as “spam” from the database:
DELETE FROM wp_comments WHERE wp_comments.comment_approved = 'spam';
Works great in all versions of WordPress including 3.0!
Keep Reading