[Summary view] [Print] [Text view]

   1  <?php
   2  if ($script_name = basename($HTTP_SERVER_VARS["SCRIPT_NAME"]) == ".php" ) {
   3   print "<meta http-equiv=\"refresh\" content=\"0; URL=../index.php\">";
   4   exit;
   5  }
   6  $patrol = "<a href=./index.php?csv_ranks=Y>All</a>&nbsp;";
   7  $sql = mysql_query('select patrol_name from tbl_patrols order by record_key');
   8  while ($row = mysql_fetch_assoc($sql)) {
   9   extract($row);
  10   $patrol = $patrol . "<a href=\"./index.php?csv_ranks=Y&View_Patrol=$patrol_name\">$patrol_name</a>$nbsp;";
  11  }
  12  mysql_free_result($sql);
  13  ?>
  14  
  15  <center><h2>Rank Progress Chart</h2><br>
  16  
  17  
  18  <?php print $patrol; ?><br>
  19  
  20  <table class=white border=1 widht=100%>
  21   <tr>
  22    <td width=125 align=center><b>Scout Name</td>
  23    <td width=125 align=center><b>Scout Badge</td>
  24    <td width=125 align=center><b>Tenderfoot</td>
  25    <td width=125 align=center><b>Second Class</td>
  26    <td width=125 align=center><b>First Class</td>
  27    <td width=125 align=center><b>Star</td>
  28    <td width=125 align=center><b>Life</td>
  29    <td width=125 align=center><b>Eagle</td>
  30   </tr>
  31  
  32  <?php
  33  if ($View_Patrol != '') {
  34   $where = "where patrol='$View_Patrol'";
  35  }
  36  
  37  $sql = mysql_query("select first_name,last_name,record_key from tbl_scout $where order by birthdate");
  38  
  39  
  40  while ($data = mysql_fetch_assoc($sql)) {
  41   print " <tr>\n  <td>" . $data['first_name'] . " " . $data['last_name'] . "</td>";
  42   $sql_rank = mysql_query('select rank_key,date from tbl_scout_rank where scout_key = ' . $data['record_key'] . ' and req_num = 0 order by rank_key');
  43   while ($rank_data = mysql_fetch_assoc($sql_rank)) {
  44    print "\n  <td>" . $rank_data['date'] . "</td>";
  45   }
  46   mysql_free_result($sql_rank);
  47   print "\n </tr>";
  48  }
  49  mysql_free_result($sql);
  50  ?>
  51  
  52  </table></center>