--- 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("\"%s\" ", $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"];