<?php
include "db.php";
include "table.php";

$table = new Table("text_data");

$query = "SELECT * FROM schools WHERE status IN ('Active','Special') ORDER BY record_num";
$schools = db_query($query);

$date_added = date("Y-m-d",time());
$date_modified = date("Y-m-d",time());

while ($row = db_fetch_array($schools)) {
   $school_num = $row['record_num'];

   $text_id = "Class List Message";
   $data_code = "Message";

   $results = db_query("SELECT * FROM text_data WHERE school_num = $school_num AND text_id = '$text_id'");
   if (db_num_rows($results) == 0) {
      $text_data = "";
      $query = $table->BuildInsert();
      db_query($query);
   }

}


?>