[Summary view] [Print] [Text view]

   1  <?php
   2  if ($script_name = basename($HTTP_SERVER_VARS["SCRIPT_NAME"]) == "counselor.php" ) {
   3   print "<meta http-equiv=\"refresh\" content=\"0; URL=../index.php\">";
   4   exit;
   5  }
   6  
   7  print "<center><h2>Counselor List</h2></center>";
   8  
   9  if ($mb == '') {
  10   $where = '';
  11  } else {
  12   $where = "and c.badge_number=$mb";
  13  }
  14  
  15  print "<table class=white>";
  16  
  17  $sql = mysql_query("select * 
  18                      from tbl_counselor a,tbl_counselor_mb b,tbl_merit_badge c
  19                      where a.record_key = b.couns and b.mb = c.badge_number $where
  20                      order by badge_name
  21                     ");
  22  
  23  while ($row = mysql_fetch_assoc($sql)) {
  24   extract($row);
  25   if ($hold_badge_name != $badge_name) {
  26    print "<tr><td colspan=4 align=center><h3>$badge_name</h3></td></tr>";
  27   }
  28   $hold_badge_name = $badge_name;
  29   print "<tr><td>$first_name $last_name</td><td>$home_phone</td></tr>";
  30  }
  31  mysql_free_result($sql);
  32  print "</table>";
  33  
  34  ?>