Skip to content

Tag Archives: Tips & Tricks

Another way of joining table without JOIN syntax in SQL

28-Apr-09

We often use JOIN syntax for joining 2 or more tables in SQL. Such as INNER JOIN, OUTER JOIN, etc. But here I found another way of joining table that much like INNER JOIN, that is by tricking WHERE syntax.
Below is the example of INNER JOIN between table Customer and Member:

SELECT customer.name, member.name
FROM customer INNER [...]

The Easiest Way of Making Money with Google Adsense

11-Apr-09

If you have Google Adsense, I bet you do know how hard it is to make money with it. You have to master all of webby things such as analyzing visitors, maintain your traffic, SEO, writing nice article, and a dozen of skills which to make your website a making money website.
Google Adsense is hard, [...]

PHP: Convert If to Switch

23-Dec-08

I have been being asked by some friends of mine, that is in PHP language how to convert If statement into Switch statement (in some cases, using Switch is for shortening code).
At first, I thought that Switch was just only for ‘equal’ comparison. But actually it is more than just equal. So I did a [...]