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