MySQL and Multiple Tables: Part 2
Last time we introduced designing a MySQL database with multiple tables in mind. We discussed the basics of how to put together some SQL to JOIN our tables together in useful ways. This tutorial follows on, looking a bit closer at using the database we created in Dreamweaver.
This time we're going to look at using some JOIN queries in a web application, using Dreamweaver MX 2004 and its server behaviours. Again we'll be using our CD database as an example. We'll also look at some of the functions we can use to group rows returned by our queries together.
A man of many talents, Matt has been a web designer, technical editor, and jewellery picker. He is currently on contract for the Birmingham City University, producing pages for research centres.
He has tech-edited a dozen books on web design and development for glasshaus, Apress and Sitepoint.
He likes music with loud guitars and games with obscure rules.
His website can be found at: http://www.eclecticdreams.com
He lives in Birmingham with his girlfriend, Frances, and a horde of spider plants.
You must me logged in to write a review.