If your table is updated often, queries will rarely pull from cache. Depending on your situation, performance may be more important than up-to-the-second data accuracy.
Image Sitemap Generation with PHP
It's natural for us to want to squeeze every ounce of SEO juice out of our websites. Image Sitemaps are yet another channel to feed…
PHP Data Feeds – Export Database to CSV
I develop in a few languages, but I use PHP for just about all of my data feeds. I do so because the PHP scripts…
Just upload a CSV, websites understand those better
"Just upload a CSV", says the developer to the scared little product manager. Sure, it may be easier for any script to parse a CSV…
Structuring your Site – Layout vs. Templates
When I hear the word layout, what instantly comes to mind is a Photoshop file with design details for an upcoming web project. On the…
CGI – why o why!
I'm willing to bet that if you're reading this, you're a somewhat seasoned web developer but by some requirement, you are forced to create a…
Don’t rely on AJAX for form submissions
I admit to cutting corners when it comes to graceful degradation, but one area where you certainly don't want to skimp is form submissions. Let's…
WP E-Commerce Google Product Feed errors
WP E-Commerce is full-featured enough that it provides us with a Google Product feed "out of the box". But, at no fault of the WP…
WP E-Commerce product meta data
If you've been involved in a moderately custom e-commerce store based on the WP-Ecommerce WordPress plugin, you've probably come across the need to display product…
PHP build from source – can’t find libraries
I see this issue posted on countless threads, and the majority of the time, it is because PHP is not aware that you are on…