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

su_id	su_name	su_author	co_id	co_su	co_title	co_level	co_key
8	Tcl	John Ousterhout	119	8	Tcl Programming	2	tb
8	Tcl	John Ousterhout	120	8	The Tk Toolkit	3	tk
8	Tcl	John Ousterhout	117	8	Learning to program in Tcl	1	tl
7	Scala	Martin Odersky	[null]	[null]	[null]	[null]	[null]
4	Ruby	Yukihiro "Matz" Matsumoto	110	4	Learning to program in Ruby	1	rl
4	Ruby	Yukihiro "Matz" Matsumoto	111	4	Ruby Programming	2	rp
4	Ruby	Yukihiro "Matz" Matsumoto	112	4	Rails for Ruby	3	rr
3	Python	Guido Van Rossum	109	3	Learning to Program in Python	1	yl
3	Python	Guido Van Rossum	121	3	Python Programming	2	yp
2	PHP	Rasmus Lerdorf	104	2	Learning to Program in PHP	1	pf
2	PHP	Rasmus Lerdorf	106	2	PHP Programming	2	ph
2	PHP	Rasmus Lerdorf	107	2	OO Programming in PHP	3	po
2	PHP	Rasmus Lerdorf	108	2	PHP Techniques Workshop	3	pt
1	Perl	Larry Wall	101	1	Learning to program in Perl	1	lp
1	Perl	Larry Wall	102	1	Perl for Larger Projects	3	pl
1	Perl	Larry Wall	105	1	Perl Programming	2	pp
1	Perl	Larry Wall	103	1	Using Perl on the Web	3	pw
5	Lua	Roberto Ierusalimschy	116	5	Lua Programming	2	ub
5	Lua	Roberto Ierusalimschy	115	5	Learning to program in Lua	1	ul
11	Java	- -	128	11	Apache httpd and Tomcat Deployment	3	at
11	Java	- -	127	11	Java Bootcamp	2	bj
11	Java	- -	126	11	Learning to Program in Java	1	sj
10	Go!	Robert Griesemer, Ken Thompson, Rob Pike	[null]	[null]	[null]	[null]	[null]
[null]	[null]	[null]	124	9	Introduction to Linux Administration	2	la
[null]	[null]	[null]	123	9	Linux Basics	1	lb
[null]	[null]	[null]	125	9	Linux Web Server	3	lw
[null]	[null]	[null]	114	6	MySQL	1	mq

Training sample © 2012, 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