Alvin - who has written 338 posts on Alvin Poh’s Blog.
Alvin is a Singaporean who's interested in marketing, techy stuff and likes to just figure out how the two can work with each other. On top of his blog, you can also follow him on Twitter.
In MySQL, there are 5 different integer types, and each type allows for different integer value sizes. In addition, each type can be signed or unsigned. If your value is always positive, then you can make your integer type unsigned. The following are the values that different integer types (signed/unsigned) can hold: Integer Type Start [...]
Continue reading...Sunday, May 15, 2011
I have a Logitech keyboard that was acting up on me and squeaking when I type on it. It got so bad that I couldn’t take it anymore and went to find a way. Turns out that there’s a pretty cheap way to fix squeaky keyboards. The solution? Silicone spray (Get it from Amazon). Silicone [...]
Continue reading...Thursday, April 21, 2011
If you try to map a network drive in Windows, and use different user credentials, you’ll realise that you’ll need to always type in the username and password every single session. If you shut down your computer everyday, that means you’ll need to do this on a daily basis. This is horrible too, if you [...]
Continue reading...Monday, April 11, 2011
I had an application that had a long list of checkboxes in a form. I wanted the ability to check all the checkboxes at once, or uncheck them at once. However, after googling for a solution, it seemed that all of them required me to label all my checkboxes with the same name. The nature [...]
Continue reading...Friday, April 1, 2011
The Thecus N4100Pro NAS is a relatively old model, but very affordably priced. It doesn’t have as many features as other models in the 4-bay NAS range, such as the QNAPs or Synologys, but it does what I needed it to do well, which was to be a primary fileserver. Thecus N4100Pro NAS Packaging It’s [...]
Continue reading...Wednesday, March 30, 2011
I had a table’s worth of listings and had stored all the values in a multidimensional array in PHP. The problem was, I needed to sort the multidimensional array, but based on just one element. Here’s the easiest, fastest solution that I found from the array_multisort function page of PHP (thanks to zequez at gmail [...]
Continue reading...Tuesday, March 22, 2011
If you’re developing an application that makes use of SQL statements, you may come across a time when you’ll require to count() values from a table. You may also come across a time when you’ll need to subtract a count() value from another. The good news is that you don’t have to retrieve both count() [...]
Continue reading...
Tuesday, July 12, 2011
0 Comments