--- trunk/rqs.phtml 2004/01/28 16:44:01 21
+++ trunk/rqs.phtml 2004/03/04 22:43:50 42
@@ -77,14 +77,14 @@
}
$sql .= " ORDER BY mi.masterinfotype, i.infotype";
- $rs = mysql_query($sql, $con);
- $rows = mysql_num_rows($rs);
+ $rs = xx_query($sql, $con);
+ $rows = xx_num_rows($rs);
// initialize
$last_masterinfotype_id = 0;
$rowcount = 0;
- while ($row = mysql_fetch_array ($rs)) {
+ while ($row = xx_fetch_array ($rs)) {
// Fetch information types for this subject
$infotype_id = $row["infotype_id"];
@@ -123,8 +123,8 @@
$sql = "SELECT subject, subject_descr FROM subject WHERE subject_id = "
. $subject_id;
-$rs = mysql_query($sql, $con);
-$row = mysql_fetch_array ($rs);
+$rs = xx_query($sql, $con);
+$row = xx_fetch_array ($rs);
$subject = $row["subject"];
$subject_descr = $row["subject_descr"];
@@ -194,9 +194,9 @@
rsi.resource_id = r.resource_id
ORDER BY m.masterinfotype, i.infotype, r.title";
-$rs = mysql_query($sql, $con);
+$rs = xx_query($sql, $con);
-while ($row = mysql_fetch_array ($rs)) {
+while ($row = xx_fetch_array ($rs)) {
// Fetch information types for this subject
$masterinfotype = $row["masterinfotype"];
@@ -238,10 +238,10 @@
. $resource_id
. " AND rf.feature_id = f.feature_id";
- $f_rs = mysql_query($f_sql, $con);
+ $f_rs = xx_query($f_sql, $con);
- while ($f_row = mysql_fetch_array ($f_rs)) {
+ while ($f_row = xx_fetch_array ($f_rs)) {
$image_path = $f_row["image_path"];
$image_alt = $f_row["image_alt"];
printf(" ", $image_path, $image_alt);
@@ -259,7 +259,7 @@
// Link to library holdings if something was supplied for catalog number
if (strlen($cat_num) > 0)
- printf("
Check Catalog", $cat_num);
+ printf("
Check Catalog", $cat_num);
// Swap variables
$last_m = $masterinfotype;
@@ -282,8 +282,8 @@
subject.sublocation_id = location.location_id";
// Fetch the values
-$rs = mysql_query($sql, $con);
-$row = mysql_fetch_array ($rs);
+$rs = xx_query($sql, $con);
+$row = xx_fetch_array ($rs);
$location_id = $row["location_id"];
$location = $row["location"];
$location_descr = $row["location_descr"];
@@ -331,12 +331,12 @@
sub_loc.location_id = location.location_id";
// Fetch the values
-$rs = mysql_query($sql, $con);
+$rs = xx_query($sql, $con);
// Initialize
$rowcount = 0;
-while ($row = mysql_fetch_array ($rs)) {
+while ($row = xx_fetch_array ($rs)) {
$location_id = $row["location_id"];
$location = $row["location"];