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 their Authors

logging into MySQL database: done
selecting database: done
defining query: SELECT * FROM confPaper, confAuthorPaper, confAuthor WHERE confPaper.paperID = confAuthorPaper.paperID AND confAuthor.authorID = confAuthorPaper.authorID ORDER BY title, last, first
executing query: done

A Conceptual Approach to Teaching Induction for Computer Science

• Status: accepted
• Authors:
  • Malek Adjouadi, Florida International University
  • Ana Pasztor, Florida International University
  • Irene Polycarpou, Florida International University

Bantam: A Customizable, Java-Based, Classroom Compiler

• Status: submitted
• Authors:
  • Marc Corliss, Hobart and William Smith Colleges
  • Christopher Lewis, VMware, Inc.

Incorporating Transformations into JFLAP for Enhanced Understanding of Automata

• Status: submitted
• Authors:
  • Jonathan Jarvis, Advanced Micro Devices
  • Joan Lucas, State University of New York, College at Brockport

Language Design and Implementation using Ruby and the Interpreter Pattern

• Status: accepted
• Authors:
  • Ariel Ortiz, Tecnologico de Monterrey, Campus Estado de Mexico

Language Engineering in The Context of A Popular, Inexpensive Robot Platform

• Status: accepted
• Authors:
  • Li Xu, UMass Lowell

Teaching Students to Think Nondeterministically

• Status: accepted
• Authors:
  • Michal Armoni, Weizmann Institute of Science
  • Mordechai Ben-Ari, Weizmann Institute of Science
  • Noa Lewenstein, Netanya Academic College