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 © 2023, WELL HOUSE CONSULTANTS LTD
This is
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: • WEB: