McGoo_Query 3.0 - An Exercise in AJAX, PHP and MySQL
SQL:




Output:
  1. When typing in an SQL statement, press [Ctrl] and [Shift] keys together to run the query.
  2. Please use double quotes, not single quotes, to show strings in queries
    Use: Select * from Movies where movname = "Fool's Gold"
    Not: Select * from Movies where movname = 'Fool's Gold'
    This prevents problems with names that include apostrophes.
  3. In LIKE statements, MySQL uses:
    the percent sign(%) and the underscore sign (_) as the wildcards
    not asterix(*) & question mark(?) as in MS Access SQL.
  4. Use the View HTML button to view, select and copy the SQL output as HTML.
  5. Download a template to paste you answers into. (Right-click - Save Link/Target As...)
  6. This software uses the following technologies:
    SQL - Structured Query Language
    MySQL DBMS - DataDase Management Service
    PHP - PHP Hypertext Preprocessor
    HTML - HyperText Markup Language and CSS - Cascading Style Sheets
    Javascript - Browser Scripting Language using AJAX - Asynchronous Javascript and XML via the Prototype Library
    HTML DOM - HTML Document Object Model
  7. McGoo uses and recommends the very useful tutorials found at:
    Visit W3Schools W3Schools - Free HTML, CSS, JavaScript, PHP, SQL tutorials with lots of working examples and source code.
McGoo_Query 3.0 © 2012: Dave McGuinness - (Build:2012-01-01)

McGoo_Query is provided as a service to Queensland schools offering the Queensland Studies Authority subject, Information Processing and Technology.

The application is intended to be used to accompany textbook exercises from works such as Leading Technology by Kevin Savage. A number of the accompanying databases, including School, Movies, Repairs and Pms, are sourced from Kevin's work.

The Egypt database is originally from an ancient textbook by Offer and Thompson.

The Shares database comes from a very early edition of Borland Delphi.