/[libdata]/branches/paul_xx/rqs.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 /branches/paul_xx/rqs.phtml

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

branches/paul/rqs.phtml revision 68 by dpavlin, Thu Mar 18 19:24:54 2004 UTC branches/paul_xx/rqs.phtml revision 69 by dpavlin, Thu Mar 18 20:01:09 2004 UTC
# Line 77  if ($pf != 1) { Line 77  if ($pf != 1) {
77          }          }
78    
79          $sql .= " ORDER BY mi.masterinfotype, i.infotype";          $sql .= " ORDER BY mi.masterinfotype, i.infotype";
80          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
81          $rows = mysql_num_rows($rs);          $rows = xx_num_rows($rs);
82    
83          // initialize          // initialize
84          $last_masterinfotype_id = 0;          $last_masterinfotype_id = 0;
85          $rowcount = 0;          $rowcount = 0;
86    
87          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
88    
89                  // Fetch information types for this subject                  // Fetch information types for this subject
90                  $infotype_id = $row["infotype_id"];                  $infotype_id = $row["infotype_id"];
# Line 123  if ($pf != 1) { Line 123  if ($pf != 1) {
123  $sql = "SELECT subject, subject_descr FROM subject WHERE subject_id = "  $sql = "SELECT subject, subject_descr FROM subject WHERE subject_id = "
124          . $subject_id;          . $subject_id;
125                    
126  $rs = mysql_tryquery($sql);  $rs = xx_tryquery($sql);
127  $row = mysql_fetch_array ($rs, MYSQL_ASSOC);  $row = xx_fetch_array ($rs, xx_ASSOC);
128  $subject = $row["subject"];  $subject = $row["subject"];
129  $subject_descr = $row["subject_descr"];  $subject_descr = $row["subject_descr"];
130    
# Line 200  $sql = "SELECT Line 200  $sql = "SELECT
200          rsi.resource_id = r.resource_id          rsi.resource_id = r.resource_id
201          ORDER BY m.masterinfotype, i.infotype, r.title";          ORDER BY m.masterinfotype, i.infotype, r.title";
202    
203  $rs = mysql_tryquery($sql);  $rs = xx_tryquery($sql);
204    
205  while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {  while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
206    
207          // Fetch information types for this subject          // Fetch information types for this subject
208          $masterinfotype = $row["masterinfotype"];          $masterinfotype = $row["masterinfotype"];
# Line 250  while ($row = mysql_fetch_array ($rs, MY Line 250  while ($row = mysql_fetch_array ($rs, MY
250                  . $resource_id                  . $resource_id
251                  . " AND rf.feature_id = f.feature_id";                  . " AND rf.feature_id = f.feature_id";
252    
253          $f_rs = mysql_tryquery($f_sql);                  $f_rs = xx_tryquery($f_sql);            
254    
255    
256          while ($f_row = mysql_fetch_array ($f_rs, MYSQL_ASSOC)) {          while ($f_row = xx_fetch_array ($f_rs, xx_ASSOC)) {
257                  $image_path = $f_row["image_path"];                  $image_path = $f_row["image_path"];
258                  $image_alt = $f_row["image_alt"];                  $image_alt = $f_row["image_alt"];
259                  printf("<img src=\"%s\" alt=\"%s\">&nbsp;", $image_path, $image_alt);                  printf("<img src=\"%s\" alt=\"%s\">&nbsp;", $image_path, $image_alt);
# Line 304  $sql = "SELECT * Line 304  $sql = "SELECT *
304          subject.sublocation_id = location.location_id";          subject.sublocation_id = location.location_id";
305    
306  // Fetch the values  // Fetch the values
307  $rs = mysql_tryquery($sql);  $rs = xx_tryquery($sql);
308  $row = mysql_fetch_array ($rs, MYSQL_ASSOC);  $row = xx_fetch_array ($rs, xx_ASSOC);
309  $location_id = $row["location_id"];  $location_id = $row["location_id"];
310  $location = $row["location"];  $location = $row["location"];
311  $location_descr = $row["location_descr"];  $location_descr = $row["location_descr"];
# Line 353  $sql = "SELECT * Line 353  $sql = "SELECT *
353          sub_loc.location_id = location.location_id";          sub_loc.location_id = location.location_id";
354    
355  // Fetch the values  // Fetch the values
356  $rs = mysql_tryquery($sql);  $rs = xx_tryquery($sql);
357    
358  // Initialize  // Initialize
359  $rowcount = 0;  $rowcount = 0;
360    
361  while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {  while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
362    
363          $location_id = $row["location_id"];          $location_id = $row["location_id"];
364          $location = $row["location"];          $location = $row["location"];
Legend:
Removed from v.68  
changed lines
  Added in v.69
  ViewVC Help
Powered by ViewVC 1.1.26