On DevShed.com this morning, they have a new article for anyone out there that's looked at SQL queries and thought "there has to be a better way".

In Dynamically Insert and Update Values In a MySQL Database Using OOP, the author shows you how, using a simple PHP class, to use the variable names to match the column names and perform simple operations like an insert. From there, they move into a real user experience and create a form to POST the results to the class you've just created. And, now that you have that example down pat, they show a slight modification with an UPDATE statement using the same format.

I'm glad that this piece went above and beyond the typical "database layer" that so many sites have presented. Using this approach can be quite a load of your back as well...