How to join the same table three times in a single SQL query statement?

Having more than one join to the same table can be confusing. More than one join can quickly create a messy SQL statement. If you don’t use aliases they can quickly become difficult to read. If your database tables need to have three or more columns with the same relationship to another table. You can […]

How to use a local fallback in the event a CDN isn’t available for jQuery

Worried about using a CDN? Worried about a CDN being down? Concerned a CDN might slow your site down? Thinking there must be a down side to accessing files from a CDN? Fear not a CDN (Content Delivery Network) is a globally distributed network of servers deployed in many data centers. Giving you several advantages: […]

How to integrate a WordPress.com blog RSS feed into a PHP page

What comes first your wordpress blog or your website? You might have started with a free wordpress blog. Then later created a separate website or vice versa. Well whichever way round it is. You might have ended up with two disconnected websites. Now you want to reuse your wordpress.com blog content in your website. One […]

When to use USING in a JOIN rather than JOINing ON?

What is the difference between ON and USING() when JOINing two or more tables together in a SQL query? For example you have the following two tables, Users and Products, when a Product is created, the Users id that created it is stored. Products table: id Primary Key created_by_user_id Foreign Key to Users table product_name […]

How to join the same table twice in a single SQL query statement?

Having more than one join to the same table can be confusing. You might not have even thought it was possible to have multiple joins to the same table. It is possible and easy to do with the help of aliases. Aliases for table names Aliases allow you to reference the table name with an […]

Help for avoiding undefined index notices

If you are just starting out with PHP, you may come across this message: Notice: Undefined index: username in C:\wamp\www\mysite\index.php on line 99 Even if you’ve been coding for years you can still get this message! You may be confused as to what an “Undefined index” is? Often seen when trying to access global server variables […]

How to stay productive when traveling and working as a Web Developer

Working remotely and traveling is a balancing act of maintaining your productivity whilst keeping up to date on your work.  Keeping your clients / customers / boss happy and continuing to earn money at the same time as enjoying your travels to new cities, countries and continents. Traveling and unexpected delays in traveling along with […]

How can I forward calls and SMS messages from one country to another?

Working remotely in different countries and want to keep a phone number active in your home country?  Travelling and needing to re-direct your calls and forward SMS text messages? There can be times when you might not want your clients to know you are on the road or abroad in a foreign country.  To be […]

How to get paid, when you work remotely from your client as a Freelance Web Developer?

If you are working remotely from your client there is a good chance you are in a different country.  Payment providers charge fees and use favorable  (for them) exchange rates and banks love to charge fees whenever they can. There are a lot of options out there, a favorite for many is PayPal, but… “It […]