My Thoughts

Similar to my previous post on how to update with multiple join statements , this time, I need to delete rows in a table, but with extra criteria which made me need to join the table before deleting the rows. To do this, there are several ways, however, I found this method is the easiest: DELETE A FROM TABLE1 A LEFT JOIN TABLE2 B ON A.ROWID = B.ROWID WHERE A.first_name = 'James' AND B.last_name = 'Bond'

This happened to me today. It looks like the license of my cPanel has run out and I need to access the database in urgent. Luckily the FTP access still working so I can install phpMyAdmin manually that way. However, being a lazy person, I found a quicker and less labour intensive. To open phpMyAdmin without cPanel, you will just need to open this link: http://www.yourdomain.com:2083/3rdparty/phpMyAdmin/index.php Obviously, you need to change yourdomain.com to your correct domain and if your cPanel is on a different port, you need to change the port number as well, but other than that, the link should work.

Have you ever feel very frustrated because your HD video created using Windows Live Movie Maker has a black border on the sharing result? I did ~.~ Frustrated and felt desperate, I just closed Windows Live Movie Maker, and planed to buy another video editing program. But then, while I browse on internet to search alternative for Windows Live Movie Maker, I realized there is a button in this program to change the aspect ratio!! By default, the aspect ration is 4:3 which is not a widescreen format. That's why my vid came with black edge. I really don't know why Microsoft do something like this while the majority of screen produced right now are widescreen. Probably this is an old program that still come with new Windows? Anyway, to change the aspect ratio, click on view -> Aspect ratio -> Widescreen (16:9). So simple as that @_@ The result was not too bad, below you can see the example of editing that I done on Microsoft Live Movie Maker, with 1280x720 HD size. The conclusi...

Hiren Boot CD is a superb all in one tools, that helps from regular user to the IT tech guys alot. If you boot this CD, you will find heaps of tools such as: mini windows XP, recovery, backup, partition, and other tools. But the problem is, if your optical drive is using SATA connection, sometimes Hiren's bootCD will required drive emulation as it only support ATA optical drive. The result: it won't be able to loads it's driver. So one way to solve the computer with SATA optical drive is by using Hiren in USB instead. In this post, I'll show you step by step on how I did it (credit goes to hiren.info for the information). Connect a USB Drive (256Mb or more). Right click the USB drive in Windows Explorer, and choose format (this step will destroy all the data inside the USB stick, so make sure you already have backup the data you need). You can tick quick format if you are sure the USB stick is still in a good condition, or just untick it if you afraid you have badsector...

Tired of slow, easy to crash and unstable Windows? Wonder what can you do to make your Windows faster? Then you come to the right place, try to read this article. Windows is an operating system, means it is provide an user interface that help a person to interact with the machine. Because the complexity of a computer, we as human can not get in control directly to every things that happened inside it. For example, if we install a new program. What we can do is we rely on our operating system to decide where they will save our file in our hard drive, rely on them to decide what registry to be saved, even nowadays people tend to trust a software and do the silent install -means accept all things by default- instead of doing custom installation. This make things worse sometimes, because we lost control on what our computer doing. Lots of software come and go as the time fly, update installed without being control, and unused registry still stay in our system, even no program ever use it. ...