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"]; |
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 |
|
|
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"]; |
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\"> ", $image_path, $image_alt); |
printf("<img src=\"%s\" alt=\"%s\"> ", $image_path, $image_alt); |
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; |
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"]; |
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"]; |