Useful MySQL Queries For Merging & Restoring Databases

Chris — March 2, 2009

My MySQL skills are very adequate. Even though I don’t know how to build a perfect database structure I can query most everything. That being said, I don’t do much advanced stuff on a regular enough basis to be able to write SQL with my eyes shut. One thing I’ve never had to do is [...]

Categories: MySQL,Web Development — Tags: , , ,

Excluding Categories from Your WordPress RSS Feed

Chris — March 1, 2009

As a supplement to my previous post about having a separate template for a specific category I thought I should let you know how I excluded a category from a RSS feed. Say you have a news category that looks different and says something different than the rest of your blog, you might want to [...]

Categories: Web Development,Wordpress — Tags: , , ,

Use Different Single Post Templates for Different Categories in WordPress

Chris — February 24, 2009

I recently had to figure out how to use a separate post template for a specific category like you can with pages in wordpress. I found a solution at nathanrice.net. Just add the following code to you functions.php file: <?php add_filter(‘single_template’, create_function(‘$t’, ‘foreach( (array) get_the_category() as $cat ) { if ( file_exists(TEMPLATEPATH . “/single-{$cat->term_id}.php”) ) [...]

Using sIFR

Chris — February 20, 2009

One of the most limiting aspects of web design is the fact that you’re limited to only a few standard fonts. Since I’m already slightly impaired in the design department missing one tool is a pretty big problem. Until CSS 3′s font support becomes a standard there’s only a few alternatives. I’ve been seeing a [...]

Categories: Web Development — Tags: ,

Second Loop in WordPress

Chris — January 13, 2009

Twice today I wanted, tried and failed to create a loop to list all the children pages of the current page in wordpress. Adn yes I know I could use “wp_page_menu” or “wp_list_pages” but the problem is I wanted to include custom fields in the output. Look at my works page. I wanted each website [...]

Categories: Web Development,Wordpress — Tags: , ,