Archive for the ‘sql’ Category
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 [...]
