<?php

include "db.php";

$mids = array(
            '368740001',
            '368740016',
            '368740019',
            '368740043',
            '368740044',
            '368740047',
            '368740048',
            '368740057',
            '368740062',
            '368740080',
            '368740090',
            '368740116',
            '368740117',
            '368740138',
            '368740162'
            );

for ($i = 0; $i < count($mids); $i++) {
   $mid = $mids[$i];

   $query = "SELECT school_name,bambora_parent_id,record_num FROM schools WHERE bambora_merchant_id = '$mid'";
   $results  = db_query($query);

   if (db_num_rows($results) == 1) {
      $row = db_fetch_assoc($results);
      extract($row);
      echo("$school_name - $bambora_parent_id\n");

      db_query("UPDATE schools SET bambora_parent_id = '388200000' WHERE record_num = $record_num");
   }
   else {
      while ($row = db_fetch_assoc($results)) {
         extract($row);
         echo(" -> $school_name - $bambora_parent_id\n");

         db_query("UPDATE schools SET bambora_parent_id = '388200000' WHERE record_num = $record_num");
      }
   }
}


?>