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

Delete Races - Database Maintenance Scripts

Produces a webpage form for deleting previously recorded races and
deletes the selected races from the racing.race and racing.drivers database table


Script: delete_races_form.php

Input

From Maintenance Menu:
  1. home_club | text
  2. validate | text
From racing database:
  1. race.Race_ID | integer
  2. race.Type | text
  3. race.Race_Class | text
  4. race.Status | text
  5. race.Race_Date | date
  6. html.Head | text
  7. html.Menu_Top | text
  8. html.Tail | text
  9. validate.Mode | text
Actions



Output

To delete_races.php on Delete Races:
  1. Race_ID | integer | array
  2. home_club | text
  3. validate | text
To Display:



Script: delete_races.php

Input

From delete_drivers_form.php: See Output above

From racing database:
  1. html.Head | text
  2. html.Menu_Top | text
  3. html.Tail | text
  4. validate.Mode | text
  5. race.Results_Array | array for each race
  6. drivers.Races_Points | array for each driver
  7. drivers.Car_Class | array for each driver
Actions



Output

To racing database:
  1. Delete selected race(s) from the racing.race table
  2. Update Races_Points and Car_Class in racing.drivers for each driver
To Display: