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 Authors and their Paper IDs

logging into MySQL database: done
selecting database: done
defining query: SELECT * from confAuthor, confAuthorPaper WHERE confAuthor.authorID = confAuthorPaper.authorID ORDER BY last
executing query: done
First Name Last Name Organization email Address Paper Number
Malek Adjouadi Florida International University made-up-6@school4.edu 2
Michal Armoni Weizmann Institute of Science made-up-1@school1.edu 1
Mordechai Ben-Ari Weizmann Institute of Science made-up-3@school1.edu 1
Marc Corliss Hobart and William Smith Colleges made-up-8@school6.edu 4
Jonathan Jarvis Advanced Micro Devices ficticious1@company1.com 3
Noa Lewenstein Netanya Academic College made-up-2@school2.edu 1
Christopher Lewis VMware, Inc. ficticious2@company2.com 4
Joan Lucas State University of New York, College at Brockport made-up-7@school5.edu 3
Ariel Ortiz Tecnologico de Monterrey, Campus Estado de Mexico made-up-10@school8.edu 6
Ana Pasztor Florida International University made-up-5@school4.edu 2
Irene Polycarpou Florida International University made-up-4@school4.edu 2
Li Xu UMass Lowell made-up-9@school7.edu 5
closing database: done