Developer's Tool Bag: Generating Code

Popping back in to talk about speeding up the monotonous part of coding: making the initial models that are just basic set up stuff.  My old way, Dreamweaver RegEx search/replaces doesn't work for the PHP style we're doing, so time to make a new way! 

Read more...

Comments Filed under: ColdFusion, Developer's Life, Dreamweaver, Zend

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