WordPress Themes - Watch Those Spaces!

A little space in a WordPress theme causes the RSS feed of a WordPres site to just go all borky, even though there seems to be no technical reason it should have had no impact on anything.

Read more...

Comments Filed under: PHP, WordPress

Basic Refresher on Signed vs Unsigned Integers

A quick teasing at YouTube for their little DB misdesign and a refresher on the difference in signed and unsigned integers and how MySQL handles each.

Read more...

Comments Filed under: Databases, MySQL

More Random Updates: Of Life, Work, and WordPress

Time for another random hello sort of post.  Of course it's November, so it's National Novel Writing Month time.  Also still churning away on the documentation of our next project before we begin coding and I've gotten my feet wet with WordPress.

Read more...

Comments Filed under: Developer's Life, Meta Stuff, WordPress

Discovering MySQL GROUP_CONCAT

So this week, I discovered something new in MySQL (well, new to me). A common query one might need to run is to get a list of rows from one table and it's related rows in a connected table.  But rather than having individual rows for each unique combination, wouldn't it be nice to have a single row with nice list of matching values as our second field?  Well, now I know I can do this, at least in MySQL :-)

Read more...

Comments Filed under: MySQL

Overdue Update

Wow, it's been nearly two months since my last post!  Whoops! I'm still around, it's been a strange mix of quiet and hectic lately.  So here is a bit of an update on my professional coding stuff as well as on the stuff keeping me busy in my personal life, like kitchen remodeling!

Read more...

Comments Filed under: Developer's Life, Friday Fun, PHP, Zend