CP Home
Database
Description
Script Index
I-5 QMC
MySQL
Database
SQL
PHP
HTML
Email

Race Results - Database Maintenance Scrips

Permits user to select a race date and produce a page of selected race results.


Script: race_results_form.php

Input

From Maintenance Menu:
  1. home_club | text
From racing database:
  1. html.Head | text
  2. html.Menu_Top | text
  3. html.Tail | text
Actions



Output

To race_results.php on click:
  1. Race_Date | date
  2. home_club | text
To Display:



Script: race_results.php

Input

From race_results_form.php: See Output above

From racing database:
  1. CURDATE() | today's date
  2. DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY) | yesterday's date
  3. event.Event_Num | text
  4. race.Results | html
  5. race.Race_Class | text
  6. race.Status | text
  7. race.Type | text
  8. html.Head | text
  9. html.Menu_Top | text
  10. html.Tail | text
Actions



Output

To Display: