One of the most important factors in dynamic web page development is database definition. If your tables are not set up properly, it can cause you a lot of headaches down the road when you have to perform miraculous SQL calls in your PHP code in order to extract the data you want. By understanding data relationships and the normalization of data, you will be better prepared to begin developing your application in PHP. This 6-page article describes the data relationships and the normalization of data using a simple example.

This is a short tutorial on how to program in PHP and MySQL. Covers several MySQL functions via telnet command, and a short example on using PHP with MySQL.

This tutorial explains how to access dbm files from PHP using various dbm-PHP functions.

This is the second part of creating Web-based admin user interface. This tutorial covers adding and deleting users via Web form using a MySQL database.

Everyone who likes MS HTML Help (.chm extension) can now obtain complete conversion of MySQL manual into this format. This conversion tries to bring additional functionality and make using of MySQL manual more comfortable.

The author notes, "Last week we introduced you to the basics of creating an efficient database table structure. After today's concluding article of this series you'll be able to create some of your own MySQL-powered applications, or use this syntax as the basis for learning to create normalized databases on your database server of choice."

This article addresses two SQL-related issues in PHP: 1) Creating complex, powerful, queries to take advantage of your table schemas, and 2) Building those queries on the fly according to user input.

This is a MySQL CHM (Compiled HTML Manual), based on original html-vsersion of manual from www.mysql.com.

This 6-page article explains how to create an extension to PHPLIB to work with multiple databases. You may find this article helps you extend PHPLIB in other ways. Read this article to the end and then think about situations where PHPLIB performs 98% of what you want.

A collection of 18 FAQs on connecting MySQL server with PHP scritps. Clear explanations and tutorial exercises are provided on MySQL server connection; providing port number, user account and password; selecting or creating database; running SQL statements; checking execution errors.