Most Rated Articles

Installing Apache and Apache Modules the easy way

The Essential steps on how to Sysprep Windows 7

SSH is very much similar to telnet. SSH is a shell program which allows a user remote access and the ability to execute commands over a network.

It is important to protect your wireless networks from unwanted and abusive users. Unauthorized users may reduce the bandwidth and may lock up your network

There are many methods on how to optimize apache. It could be on the software side, but upgrading the hardware also makes a difference.

With Windows 7 as a new OS in the market, one may worry about any problems that could be encountered especially network issues such as compatibility with older OS. Windows 7 might encounter problems communicating with older Windows models such as XP. The following are ways on how to network Windows 7 and XP.

One way of installing windows over the network is through the use of RIS or Remote Installation Services. However, you must have the following prerequisites in order to install Windows over the network.

Installing a printer on a mac is just as easy as installing a printer on an OS of Windows. The following steps are just some of the steps on how to connect your printer a Mac operating system.

Nowadays, it is important to have access to Wi-Fi. However, not everyone has their own internet connection so most people leech wherever there is free Wi-Fi. Most routers with Wi-Fi access require passwords but nowadays, there are other places to look around and search for free Wi-Fi.

Some applications cannot install in Windows 7 due to incompatibility issues. A solution would be to enable XP mode in a virtual environment of Windows 7. This configuration may be used to run and install programs that were incompatible in Windows 7.

Database  »  MySQL
 Picture

How to do a MySQL Join Select Query

By: Jerry Slagger
Date Added : June 27, 2010 Views : 167



The MySQL Join allows you to query multiple tables to get the desired data. For example, you may want to get the email addresses from the customers table for all customers that are active AND have posted a listing in the products table. As you can see, it would be extremely complex to try to get this data with multiple select queries. Instead, you can create a single join query to get the data you want.

When creating a join query you must format the SELECT by table.field, i.e.; customer.email.

MySQL Join Exmaple:

$query = "SELECT customer.email FROM customer, products WHERE customer.id = product.customer_id"

In the above example, customer.email and customer.id is the email and id fields in the customer table. product.customer_id is the customer_id field in the products table.

What we have done is told MySQL to select the email data from the customer table IF the customer id in the customer table is the same as the customer id in the products table.



Article Categories