<?php
include "db.php";
include "include/school-functions.php";
include "table.php";

$table = new Table("classes");


$school_num = 220;
$results = db_query("SELECT * FROM schools WHERE record_num = $school_num");
$school_record = db_fetch_assoc($results);

$new_school_num = 18447;
$new_class_program = 211;

$classes = db_query("SELECT * FROM classes WHERE school_num = $school_num ORDER BY sequence");
while ($row = db_fetch_assoc($classes)) {
   extract($row);
   $info = getClassInfo($record_num,'teacher');

   $lt = preg_replace("/^[^ ]* /","",$info);
   $lt = str_replace("-","",$lt);
   $lt = str_replace(" ","",$lt);
   $lt = preg_replace("/[a-z]/","",$lt);
   $label_description = "MG - $lt";

   $school_num = $new_school_num;
   $description = $info;
   $class_program = $new_class_program;
   $teacher1 = 0;

   $query = $table->BuildInsert();
   // echo("$query\n");
   db_query($query);
}

?>