SQL - Installation

All the examples use SQL compatible with the latest MySQL. Code examples use PHP 5. you can test the code in a web site using Apache. here are references to installation instructions.

Install Apache then MySQL then PHP then phpMyAdmin.

Apache

You can read about Apache in Apache. You can also read:
Apache 2.2 installation on Windows XP
Install Apache, MySQL, and PHP 5 in Ubuntu 11.4 using the Ubuntu Software Centre

Test Apache. you shopuld be able to see the Apache supplied welcome page.

MySQL

MySQL installation on Windows XP
Install Apache, MySQL, and PHP 5 in Ubuntu 11.4 using the Ubuntu Software Centre

PHP

Install Apache, MySQL, and PHP 5 in Ubuntu 11.4 using the Ubuntu Software Centre

Test PHP using phpMyAdmin.

phpMyAdmin

phpMyAdmin is a simple way to administer MySQL databases using PHP and Apache.

Try the examples

The SQL examples can be tested in an SQL code box in a phpMyAdmin page. The SQL examples can also be tested using a simple HTML page with some PHP code inserted in the HTML and SQL inserted in the PHP. The HTML page approach gives you the chance to save example pages for reuse.