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

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

revision 41 by dpavlin, Wed Jan 28 16:44:01 2004 UTC revision 42 by dpavlin, Thu Mar 4 22:43:50 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_query($sql, $con);          $rs = xx_query($sql, $con);
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)) {          while ($row = xx_fetch_array ($rs)) {
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_query($sql, $con);  $rs = xx_query($sql, $con);
127  $row = mysql_fetch_array ($rs);  $row = xx_fetch_array ($rs);
128  $subject = $row["subject"];  $subject = $row["subject"];
129  $subject_descr = $row["subject_descr"];  $subject_descr = $row["subject_descr"];
130    
# Line 194  $sql = "SELECT Line 194  $sql = "SELECT
194          rsi.resource_id = r.resource_id          rsi.resource_id = r.resource_id
195          ORDER BY m.masterinfotype, i.infotype, r.title";          ORDER BY m.masterinfotype, i.infotype, r.title";
196    
197  $rs = mysql_query($sql, $con);  $rs = xx_query($sql, $con);
198    
199  while ($row = mysql_fetch_array ($rs)) {  while ($row = xx_fetch_array ($rs)) {
200    
201          // Fetch information types for this subject          // Fetch information types for this subject
202          $masterinfotype = $row["masterinfotype"];          $masterinfotype = $row["masterinfotype"];
# Line 238  while ($row = mysql_fetch_array ($rs)) { Line 238  while ($row = mysql_fetch_array ($rs)) {
238                  . $resource_id                  . $resource_id
239                  . " AND rf.feature_id = f.feature_id";                  . " AND rf.feature_id = f.feature_id";
240    
241          $f_rs = mysql_query($f_sql, $con);                        $f_rs = xx_query($f_sql, $con);        
242    
243    
244          while ($f_row = mysql_fetch_array ($f_rs)) {          while ($f_row = xx_fetch_array ($f_rs)) {
245                  $image_path = $f_row["image_path"];                  $image_path = $f_row["image_path"];
246                  $image_alt = $f_row["image_alt"];                  $image_alt = $f_row["image_alt"];
247                  printf("<img src=\"%s\" alt=\"%s\">&nbsp;", $image_path, $image_alt);                  printf("<img src=\"%s\" alt=\"%s\">&nbsp;", $image_path, $image_alt);
# Line 259  while ($row = mysql_fetch_array ($rs)) { Line 259  while ($row = mysql_fetch_array ($rs)) {
259    
260          // Link to library holdings if something was supplied for catalog number          // Link to library holdings if something was supplied for catalog number
261          if (strlen($cat_num) > 0)          if (strlen($cat_num) > 0)
262          printf("<BR><a href=\"yourlibrarycatalog.here.edu\">Check Catalog</a>", $cat_num);          printf("<BR><a href=\"libdata.knjiznice.ffzg.hr\">Check Catalog</a>", $cat_num);
263    
264          // Swap variables          // Swap variables
265          $last_m = $masterinfotype;          $last_m = $masterinfotype;
# Line 282  $sql = "SELECT * Line 282  $sql = "SELECT *
282          subject.sublocation_id = location.location_id";          subject.sublocation_id = location.location_id";
283    
284  // Fetch the values  // Fetch the values
285  $rs = mysql_query($sql, $con);  $rs = xx_query($sql, $con);
286  $row = mysql_fetch_array ($rs);  $row = xx_fetch_array ($rs);
287  $location_id = $row["location_id"];  $location_id = $row["location_id"];
288  $location = $row["location"];  $location = $row["location"];
289  $location_descr = $row["location_descr"];  $location_descr = $row["location_descr"];
# Line 331  $sql = "SELECT * Line 331  $sql = "SELECT *
331          sub_loc.location_id = location.location_id";          sub_loc.location_id = location.location_id";
332    
333  // Fetch the values  // Fetch the values
334  $rs = mysql_query($sql, $con);  $rs = xx_query($sql, $con);
335    
336  // Initialize  // Initialize
337  $rowcount = 0;  $rowcount = 0;
338    
339  while ($row = mysql_fetch_array ($rs)) {  while ($row = xx_fetch_array ($rs)) {
340    
341          $location_id = $row["location_id"];          $location_id = $row["location_id"];
342          $location = $row["location"];          $location = $row["location"];
Legend:
Removed from v.41  
changed lines
  Added in v.42
  ViewVC Help
Powered by ViewVC 1.1.26