Not all real-world reporting requirements align well with how your data is organized. In my case, I had to produce sales reports tied to a US Holiday (which varies year-to-year).
Installing ImageMagick on CentOS for use with PHP
It’s not brain science, but it did take me a reasonable amount of time to figure out how to properly configure my CentOS server for using ImageMagick with PHP.
Combining multiple SQL queries for listing pages into one
With a little extra effort, you can construct a single query that returns multiple rows using the SQL IN operator.
From there, you can convert the query results into a language construct that is easy to work with.
Usability and end-of-document padding
Just an hour ago I had a client email me to let me know that they couldn’t see the text at the bottom of a…
Amazon RDS with MySQL – My Experience
Migrating a database over to Amazon RDS isn’t an all day event, but you will run into a couple snags. This post points out two issues that I ran into and quick solutions.
Slightly better fragment id scrolling
Don’t bother reading this post. It satisfies a personal itch and will appeal to maybe 1% of the webdev crowd. I’ll do better next time!
ColdFusion / PayPal Payflow REST API Integration
It was a bit of struggle using ColdFusion to integrate with PayPal’s Payflow REST API, but I worked it out and provide complete code in this post.
Are you backing up your cron table?
Most of us have some kind of secondary or off-site backup of our files & data, but may not have considered backing up the “heartbeat” of our server – the cron table.
Linux – Change file ownership from one user to another
Changing file and group ownership from one user or group to another is a common requirement in the server admin world, here are two quick tips on how to go about it.
My website is complete, but my pockets are empty
They were able to allot the funds to design and develop a website, but didn’t consider the maintenance costs that would be required to maintain the site.