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

Advancing My First Zend App, Part 3: Flipping the Layout

For today's post, I made a function for getting random items from the DB and finished the Movies home page, then started work on flipping the layout based on the section of the site you are in.

Read more...

Comments Filed under: PHP, Zend

Replacing CFGrid with DataTables, Part 3: Editable Grids

Bet you thought I forgot about this series, eh? :-)  Finally got some free time again and wrote up the last of the CFGrid to DataTables articles.  It took a little longer than I planned because of the launch of DataTables 1.10.0 since the last one was posted and it throwing some new learning curves at me.  For this round we're looking at doing in-table or grid editing, i.e. click the table field and edit it right there or insert a row without a pop up.  Great for simple data rich displays!  So let's get to it.

Read more...

Comments Filed under: ColdFusion, jQuery

Basic Fluid Grid and Responsive Design

To give my brain a bit of a rest from the Zend learning and in preparation for some future projects, I decided it was time for me to look at responsive design techniques and using CSS grids for doing site design.  Lordy was that stuff confusing!  Took me an hour or two of reading a lot of articles, and trying to separate stuff that's 5 years old from more current practices, to finally get the idea, but I managed to do it and redo a fairly standard site design using grids.  I also took it a step further and put in very basic responsiveness in the design.

Read more...

Comments Filed under: CSS, UI Fun