Database Example: JOIN in HTML/PHP

Preface

Examples for this HTML/PHP script are taken from accepted papers from SIGCSE 2008. In a few cases, the status of a paper is listed here as "submitted" rather than "accepted" to provide a better example. Independent of the information reported here, all papers were accepted and are included in the SIGCSE 2008 Proceedings, available through the ACM Digital Library.

Print Listing of Papers and the Number of Authors for Each

logging into MySQL database: done
selecting database: done
defining query: SELECT confPaper.paperID, title, status, COUNT(authorID) as count FROM confPaper, confAuthorPaper WHERE confPaper.paperID = confAuthorPaper.paperID GROUP BY confPaper.paperID, confAuthorPaper.paperID, title, status ORDER BY title
executing query: done
Paper Title Status Number of Authors
2 A Conceptual Approach to Teaching Induction for Computer Science accepted 3
4 Bantam: A Customizable, Java-Based, Classroom Compiler submitted 2
3 Incorporating Transformations into JFLAP for Enhanced Understanding of Automata submitted 2
6 Language Design and Implementation using Ruby and the Interpreter Pattern accepted 1
5 Language Engineering in The Context of A Popular, Inexpensive Robot Platform accepted 1
1 Teaching Students to Think Nondeterministically accepted 3
closing database: done