[Gran Turismo Pages ]

To contact the author by email.

Clicking one of the following items will execute a Car Finder query as if you had filled out the form.

The filled-in form will be shown on the generated page, after the results of the query. Study it to learn how the query is done. You can modify it to try a slightly different query. Note that both form and results look much better if the window is reasonably wide.

• Show all used Nissans available for days 50 to 59.
• Find those hard-to-find used Nismos in the available data.
• Give a count all used Silvias available on each day in the available data.
• Give a count of each model of used Silvias available on each day in the available data.
• Give as the count the total number of distinct records in the available data.
• Classify those same records according to Sale Type.
  Note that it is very important to sort by Sale Type to get the desired result.
  
• Determine the top 5 cars by stock power-to-weight ratio.
• Get more information about those cars.
  For efficiency, a lower bound on the power to weight ration must be chosen.
• Determine the top 5 cars by tuned power-to-weight ratio.
• Get more information about those cars.
  For efficiency, a lower bound on the power to weight ration must be chosen.
• Determine the top 5 cars by racing power-to-weight ratio.
• Get more information about those cars.
  For efficiency, a lower bound on the power to weight ration must be chosen.
  
• Find white or red used cars which tune to a power-to-weight ratio of more than .25
  Note that when using "or" you probably want it to put it early.
• Find white or red starter cars which tune to a racing power-to-weight ratio of more than .18
• See what 4wd starter cars are available when, and give some stats for them.
• Extend that search to include FR Skylines as well.
  

Sorry, this tutorial is not great, but it was easy to do.

When you have a form, basically fill in at the top of the form the characteristics, and the value you want them to match how. The tricky part is selecting the fields you want to see in the result. This form makes use of "multiple selection" for those selectors, and how to do this varies depending upon the version of the browser you are using. The Netscape we have here on UNIX interprets any mouse selection in those lists as a "toggle", while Netscape on my PC requires that the "control" key be pressed at the same time to work like that. IE on my iMac requires that the "apple" key be pressed. The "sort" menus work in a similar fashion, but can be ignored for your first queries; output will be sorted by the selected fields.