Absolute paths in PHP and Drupal
Here I'm going to show you some absolute paths in PHP and Drupal that you might need.
MySQL column to lower [SOLVED]
If you are working in a MySQL database and you want to make all rows in column to lower case for a specific table then you can do it like this:
UPDATE tablename SET columnname = LOWER(columnname);
And you're done!
MySQL Load Data Infile
Today I discovered a clever feature that MySQL has, namely writing data to a table from a file.
If you have or have had need to be able to write data using batch insert, ie. write several lines of data using a sql insert then you might have discovered that ordinary insert has limitations in number of parameters and that it takes some time to execute.
PS3 firmware 3.01 fan noise
Upgraded my PS3 to the latest firmware 3.01. Previously, I've not had any problems with fan noise when watching a DVD, but now it's worse then ever before. The fan noise is as loud as when playing games, ie. so high so that I muse increase the volume a lot to hear anything.
PHP 5.3.0RC4
PHP has released a release candidate for PHP 5.3.0 (PHP 5.3.0RC4) containing some goodies. The three most anticipated news is support for namespaces, late statistic bonding and closures.
Internet Explorer and CSS
As usual, Internet Explorer is not the best browser in terms of CSS compatibility. I found a list on MSDN that shows Internet Explorer CSS compatibility.
WAMP and Skype
New week and new solutions! I have long had problems with WAMP and Skype crashes when you start Skype before WAMP. The simple solution to this problem is simply to go into Skype and uncheck
Use port 80 and 443 as alternatives for incoming connection
MySQL large file import through console
Perhaps you have erncountered that exported database files are too large for PHP to handle even if you change upload_max_filesize, timeout etc. One solution is to do the import via MySQL console.
