Demonstration of table joins

This is a demonstration of database tables that are joined together to make a single web page ... our sample data comprises a table of programming languages (with information about each of them) and a table of courses (with some information about each of them). It is undesirable to repeat information in a table, which is why this structure was selected - however, we do need to connect up (and repeat) the data for the final presentation.

• Source of the MySQL to set up this demonstration - see here
• Source of the PHP for this page - see here

• There's an overview of joins (and a comparison of the various sorts) here
• Our MySQL courses are described here and our PHP courses here



Training sample © 2024, WELL HOUSE CONSULTANTS LTD
This is http://www.wellho.net/demo/mysql_joins.php
See source code here • More examples - same topic here
Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
Phone: +44 (0) 1225 708 225 • EMAIL: info@wellho.net • WEB: http://www.wellho.net