Creating a CMS Structure with CodeIgniter

For a long time now I’ve been wanting to build a really good CMS with CodeIgniter.
But I’m not the only one! - After searching through the CI Forums, I’ve noticed that there’s a real demand for such CMS.
About a year ago, I decided to start the ‘CodeIgnition’ Project, a CMS based on CodeIgniter. But, because [...]

MySQL: DELETE across multiple tables using JOIN.

Ever had a situation where you’ve wanted to say delete rows from lots of tables in your database that can all be associated with some form of join?
Well, after a few minutes of playing around, I’ve found a nice way to do this in just 1 query:

DELETE u, up, upc, ut, utp
FROM users AS u
LEFT [...]