Author Archives | Alvin
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.
Difference Between Integer Types in MySQL and Their Max Values
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...How To Clean A Squeaky Laptop or Computer Keyboard
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...How To Solve The Problem Of Always Having To Log On To A Network Drive In Windows
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...How To Check All Checkboxes In A Form With Javascript
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...Thecus N4100Pro Review – Best NAS for Small Office Home Office Use
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...How To Sort A Multidimensional Array By One Element In PHP
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...How To Subtract 2 Count Values Using SQL Statements
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