All posts tagged SQL


MySQL Class for PHP

This should get you started if you’re looking to connect to MySQL database.

Multi-language support in T-SQL

This is brilliant, a little scary, but brilliant. (note added July 2010: OK, A LOT SCARY!)

While back we built a website supporting unlimited languages and articles. For a reason unknown I decided to keep all my content in one table, index it and link my other tables to it.

Updates and Joins in MySQL

Now this is supremely hot. You can update a whole set of information from one table to another without passing any data from your PHP. Not sure if this works with MS SQL, I’ll check next time I’m around those machines.

Back to Top