/[libdata]/trunk/admin/rqscip_crosswalk.phtml
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/admin/rqscip_crosswalk.phtml

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 71 by dpavlin, Thu Mar 4 22:43:50 2004 UTC revision 72 by dpavlin, Thu Mar 18 20:33:37 2004 UTC
# Line 17  printf("<link rel=\"stylesheet\" href=\" Line 17  printf("<link rel=\"stylesheet\" href=\"
17  printf("</HEAD>\n");  printf("</HEAD>\n");
18    
19    
20    // Default access settings
21    $sess_time_human = "";
22    $sess_staff_account = "";
23    $sess_staff_id = 0;
24    $sess_access_level = 0;
25    $sess_access = "";
26    $sess_last_name = "";
27    $sess_first_name = "";
28    
29    
30  // Page header  // Page header
31  require_once ($GLOBAL_ADMIN_HEADER);  require_once ($GLOBAL_ADMIN_HEADER);
32    
# Line 70  if(isset($libsession) && $sess_access_le Line 80  if(isset($libsession) && $sess_access_le
80          $rowcount = 0;          $rowcount = 0;
81          $sql = "SELECT s.subject_id, s.subject, c.coursesub_id, c.coursesub, c.coursesub_descr, c.cip_code          $sql = "SELECT s.subject_id, s.subject, c.coursesub_id, c.coursesub, c.coursesub_descr, c.cip_code
82                  FROM subject s                  FROM subject s
83                  LEFT JOIN sub_coursesub sc using (subject_id)                  LEFT JOIN sub_coursesub sc on s.subject_id = sc.subject_id
84                  LEFT JOIN coursesub c on sc.coursesub_id = c.coursesub_id                  LEFT JOIN coursesub c on sc.coursesub_id = c.coursesub_id
85                  WHERE s.subject_id > 1                  WHERE s.subject_id > 1
86                  ORDER BY subject";                  ORDER BY s.subject";
87    
88          // printf("sql was: %s<BR>", $sql);          $rs = xx_tryquery($sql);
89    
90          $rs = xx_query($sql, $con);          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
           
         while ($row = xx_fetch_array ($rs)) {  
91    
92                  // Increment counter                  // Increment counter
93                  $rowcount++;                  $rowcount++;
94                                    
                   
95                  // Make every other third row colored                  // Make every other third row colored
96                  if ($rowcount % 3 == 0) $color = " class=\"backLight\" ";                  if ($rowcount % 3 == 0) $color = " class=\"backLight\" ";
97                  else $color = "";                                else $color = "";              
# Line 110  if(isset($libsession) && $sess_access_le Line 117  if(isset($libsession) && $sess_access_le
117    
118                  printf("<tr>\n");                  printf("<tr>\n");
119                                    
120                  if ($subject_id != $last_subject_id ) printf("<td>%s</td>\n", $subject_link);                  if ($subject_id != $last_subject_id) printf("<td>%s</td>\n", $subject_link);
121                  else printf("<td>&nbsp;</td>\n");                  else printf("<td>&nbsp;</td>\n");
122                                    
123                  if (strlen($cip_code) > 0) printf("<td>%s | %s [%s]</td>\n", $coursesub_link, $coursesub_descr, $cip_code);                  if (strlen($cip_code) > 0) printf("<td>%s | %s [%s]</td>\n", $coursesub_link, $coursesub_descr, $cip_code);
# Line 124  if(isset($libsession) && $sess_access_le Line 131  if(isset($libsession) && $sess_access_le
131    
132          };          };
133                    
134          printf("<tr><td colspan=\"2\" class=\"cellPlain\" align=\"center\"><br><br><b>Total Maps: %d</b><br><br></td></tr>\n", $rowcount);          printf("<tr><td colspan=\"2\" class=\"backLight\" align=\"center\"><br><br><b>Total Maps: %d</b><br><br></td></tr>\n", $rowcount);
135          printf("</table>");          printf("</table>");
136                    
137          // Link to return to admin console          // Link to return to admin console
Legend:
Removed from v.71  
changed lines
  Added in v.72
  ViewVC Help
Powered by ViewVC 1.1.26