113 |
rf.feature_id = f.feature_id ORDER BY feature"; |
rf.feature_id = f.feature_id ORDER BY feature"; |
114 |
|
|
115 |
// Fetch the current selections |
// Fetch the current selections |
116 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
117 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
118 |
$feature = $row["feature"]; |
$feature = $row["feature"]; |
119 |
$feature_id = $row["feature_id"]; |
$feature_id = $row["feature_id"]; |
120 |
printf("<option value = \"%s\">%s</option>", $feature_id, $feature); |
printf("<option value = \"%s\">%s</option>", $feature_id, $feature); |
194 |
rl.location_id = l.location_id ORDER BY location"; |
rl.location_id = l.location_id ORDER BY location"; |
195 |
|
|
196 |
// Fetch the values |
// Fetch the values |
197 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
198 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
199 |
$location = $row["location"]; |
$location = $row["location"]; |
200 |
$location_id = $row["location_id"]; |
$location_id = $row["location_id"]; |
201 |
printf("<option value = \"%s\">%s</option>", $location_id, $location); |
printf("<option value = \"%s\">%s</option>", $location_id, $location); |
275 |
rm.mastersubject_id = m.mastersubject_id ORDER BY mastersubject"; |
rm.mastersubject_id = m.mastersubject_id ORDER BY mastersubject"; |
276 |
|
|
277 |
// Fetch the values |
// Fetch the values |
278 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
279 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
280 |
$mastersubject = $row["mastersubject"]; |
$mastersubject = $row["mastersubject"]; |
281 |
$mastersubject_id = $row["mastersubject_id"]; |
$mastersubject_id = $row["mastersubject_id"]; |
282 |
printf("<option value = \"%s\">%s</option>", $mastersubject_id, $mastersubject); |
printf("<option value = \"%s\">%s</option>", $mastersubject_id, $mastersubject); |
358 |
sl.location_id = l.location_id ORDER BY location"; |
sl.location_id = l.location_id ORDER BY location"; |
359 |
|
|
360 |
// Fetch the values |
// Fetch the values |
361 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
362 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
363 |
$location = $row["location"]; |
$location = $row["location"]; |
364 |
$location_id = $row["location_id"]; |
$location_id = $row["location_id"]; |
365 |
printf("<option value = \"%s\">%s</option>", $location_id, $location); |
printf("<option value = \"%s\">%s</option>", $location_id, $location); |
441 |
st.servicetype_id = t.servicetype_id ORDER BY servicetype"; |
st.servicetype_id = t.servicetype_id ORDER BY servicetype"; |
442 |
|
|
443 |
// Fetch the values |
// Fetch the values |
444 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
445 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
446 |
$servicetype = $row["servicetype"]; |
$servicetype = $row["servicetype"]; |
447 |
$servicetype_id = $row["servicetype_id"]; |
$servicetype_id = $row["servicetype_id"]; |
448 |
printf("<option value = \"%s\">%s</option>", $servicetype_id, $servicetype); |
printf("<option value = \"%s\">%s</option>", $servicetype_id, $servicetype); |
525 |
sc.coursesub_id = c.coursesub_id ORDER BY coursesub_descr"; |
sc.coursesub_id = c.coursesub_id ORDER BY coursesub_descr"; |
526 |
|
|
527 |
// Fetch the values |
// Fetch the values |
528 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
529 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
530 |
$coursesub = $row["coursesub"]; |
$coursesub = $row["coursesub"]; |
531 |
$coursesub_id = $row["coursesub_id"]; |
$coursesub_id = $row["coursesub_id"]; |
532 |
$coursesub_descr = $row["coursesub_descr"]; |
$coursesub_descr = $row["coursesub_descr"]; |
614 |
sl.location_id = l.location_id ORDER BY location"; |
sl.location_id = l.location_id ORDER BY location"; |
615 |
|
|
616 |
// Fetch the values |
// Fetch the values |
617 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
618 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
619 |
$location = $row["location"]; |
$location = $row["location"]; |
620 |
$location_id = $row["location_id"]; |
$location_id = $row["location_id"]; |
621 |
printf("<option value = \"%s\">%s</option>", $location_id, $location); |
printf("<option value = \"%s\">%s</option>", $location_id, $location); |
697 |
sm.mastersubject_id = m.mastersubject_id ORDER BY mastersubject"; |
sm.mastersubject_id = m.mastersubject_id ORDER BY mastersubject"; |
698 |
|
|
699 |
// Fetch the values |
// Fetch the values |
700 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
701 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
702 |
$mastersubject = $row["mastersubject"]; |
$mastersubject = $row["mastersubject"]; |
703 |
$mastersubject_id = $row["mastersubject_id"]; |
$mastersubject_id = $row["mastersubject_id"]; |
704 |
printf("<option value = \"%s\">%s</option>", $mastersubject_id, $mastersubject); |
printf("<option value = \"%s\">%s</option>", $mastersubject_id, $mastersubject); |
778 |
ORDER BY s.subject"; |
ORDER BY s.subject"; |
779 |
|
|
780 |
// Fetch the values |
// Fetch the values |
781 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
782 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
783 |
$othersub = $row["subject"]; |
$othersub = $row["subject"]; |
784 |
$othersub_id = $row["othersub_id"]; |
$othersub_id = $row["othersub_id"]; |
785 |
|
|
860 |
ORDER BY p.page_title"; |
ORDER BY p.page_title"; |
861 |
|
|
862 |
// Fetch the values |
// Fetch the values |
863 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
864 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
865 |
$page_title = $row["page_title"]; |
$page_title = $row["page_title"]; |
866 |
$page_id = $row["page_id"]; |
$page_id = $row["page_id"]; |
867 |
|
|
947 |
st.staff_id = t.staff_id ORDER BY last_name, first_name"; |
st.staff_id = t.staff_id ORDER BY last_name, first_name"; |
948 |
|
|
949 |
// Fetch the values |
// Fetch the values |
950 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
951 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
952 |
$first_name = $row["first_name"]; |
$first_name = $row["first_name"]; |
953 |
$last_name = $row["last_name"]; |
$last_name = $row["last_name"]; |
954 |
$staff_id = $row["staff_id"]; |
$staff_id = $row["staff_id"]; |
1030 |
// If the user is editing an existing record, fetch previous values |
// If the user is editing an existing record, fetch previous values |
1031 |
if ($coursesub_id > 0 && $exists == 1) { |
if ($coursesub_id > 0 && $exists == 1) { |
1032 |
$sql = "SELECT * FROM coursesub WHERE coursesub_id = " . $coursesub_id; |
$sql = "SELECT * FROM coursesub WHERE coursesub_id = " . $coursesub_id; |
1033 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
1034 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
1035 |
|
|
1036 |
// Fetch existing values |
// Fetch existing values |
1037 |
$coursesub_id = $row["coursesub_id"]; |
$coursesub_id = $row["coursesub_id"]; |
1159 |
. " = " |
. " = " |
1160 |
. $key_id; |
. $key_id; |
1161 |
|
|
1162 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
1163 |
$row = mysql_fetch_array($rs); |
$row = xx_fetch_array($rs); |
1164 |
$oldValue = Trim($row[$display_field]); |
$oldValue = Trim($row[$display_field]); |
1165 |
|
|
1166 |
// Table definition |
// Table definition |
1229 |
WHERE |
WHERE |
1230 |
faculty_id = " . $faculty_id; |
faculty_id = " . $faculty_id; |
1231 |
|
|
1232 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
1233 |
$row = mysql_fetch_array($rs); |
$row = xx_fetch_array($rs); |
1234 |
|
|
1235 |
// Fetch results |
// Fetch results |
1236 |
$faculty_firstname = Trim($row["faculty_firstname"]); |
$faculty_firstname = Trim($row["faculty_firstname"]); |
1335 |
|
|
1336 |
// Fetch existing values |
// Fetch existing values |
1337 |
$sql = "SELECT * FROM feature WHERE feature_id = " . $key_id; |
$sql = "SELECT * FROM feature WHERE feature_id = " . $key_id; |
1338 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
1339 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
1340 |
$feature_id = $row["feature_id"]; |
$feature_id = $row["feature_id"]; |
1341 |
$feature = $row["feature"]; |
$feature = $row["feature"]; |
1342 |
$image_path = $row["image_path"]; |
$image_path = $row["image_path"]; |
1449 |
|
|
1450 |
// Fetch existing values |
// Fetch existing values |
1451 |
$sql = "SELECT * from infotype where infotype_id = " . $key_id; |
$sql = "SELECT * from infotype where infotype_id = " . $key_id; |
1452 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
1453 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
1454 |
$infotype_id = $row["infotype_id"]; |
$infotype_id = $row["infotype_id"]; |
1455 |
$infotype = $row["infotype"]; |
$infotype = $row["infotype"]; |
1456 |
$masterinfotype_id = $row["masterinfotype_id"]; |
$masterinfotype_id = $row["masterinfotype_id"]; |
1577 |
|
|
1578 |
// Fetch existing values |
// Fetch existing values |
1579 |
$sql = "SELECT * from location where location_id = " . $key_id; |
$sql = "SELECT * from location where location_id = " . $key_id; |
1580 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
1581 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
1582 |
$location_id = $row["location_id"]; |
$location_id = $row["location_id"]; |
1583 |
$location = $row["location"]; |
$location = $row["location"]; |
1584 |
$location_descr = $row["location_descr"]; |
$location_descr = $row["location_descr"]; |
1853 |
if ($key_id > 0 && $exists == 1) { |
if ($key_id > 0 && $exists == 1) { |
1854 |
|
|
1855 |
$sql = "SELECT * from resource where resource_id = " . $key_id; |
$sql = "SELECT * from resource where resource_id = " . $key_id; |
1856 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
1857 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
1858 |
|
|
1859 |
// Fetch existing values |
// Fetch existing values |
1860 |
$resource_id = $row["resource_id"]; |
$resource_id = $row["resource_id"]; |
2171 |
|
|
2172 |
// Fetch existing values |
// Fetch existing values |
2173 |
$sql = "SELECT * from service where service_id = " . $key_id; |
$sql = "SELECT * from service where service_id = " . $key_id; |
2174 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
2175 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
2176 |
$service_id = $row["service_id"]; |
$service_id = $row["service_id"]; |
2177 |
$service = $row["service"]; |
$service = $row["service"]; |
2178 |
$serviceURL = $row["serviceURL"]; |
$serviceURL = $row["serviceURL"]; |
2367 |
|
|
2368 |
// Fetch existing values |
// Fetch existing values |
2369 |
$sql = "SELECT * from style where style_id = " . $key_id; |
$sql = "SELECT * from style where style_id = " . $key_id; |
2370 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
2371 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
2372 |
$style_id = $row["style_id"]; |
$style_id = $row["style_id"]; |
2373 |
$style_title = $row["style_title"]; |
$style_title = $row["style_title"]; |
2374 |
$header_file = $row["header_file"]; |
$header_file = $row["header_file"]; |
2486 |
|
|
2487 |
// If the user is editing an existing record, fetch previous values |
// If the user is editing an existing record, fetch previous values |
2488 |
$sql = "SELECT * from subject where subject_id = " . $key_id; |
$sql = "SELECT * from subject where subject_id = " . $key_id; |
2489 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
2490 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
2491 |
|
|
2492 |
// Fetch existing values |
// Fetch existing values |
2493 |
$subject_id = $row["subject_id"]; |
$subject_id = $row["subject_id"]; |
2650 |
ORDER BY last_name, first_name"; |
ORDER BY last_name, first_name"; |
2651 |
|
|
2652 |
// Fetch the values |
// Fetch the values |
2653 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
2654 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
2655 |
$first_name = $row["first_name"]; |
$first_name = $row["first_name"]; |
2656 |
$last_name = $row["last_name"]; |
$last_name = $row["last_name"]; |
2657 |
$staff_id = $row["staff_id"]; |
$staff_id = $row["staff_id"]; |
2734 |
ORDER BY l.libunit"; |
ORDER BY l.libunit"; |
2735 |
|
|
2736 |
// Fetch the values |
// Fetch the values |
2737 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
2738 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
2739 |
$libunit = $row["libunit"]; |
$libunit = $row["libunit"]; |
2740 |
$libunit_id = $row["libunit_id"]; |
$libunit_id = $row["libunit_id"]; |
2741 |
printf("<option value = \"%s\">%s</option>", $libunit_id, $libunit); |
printf("<option value = \"%s\">%s</option>", $libunit_id, $libunit); |
2817 |
ORDER BY s.subject"; |
ORDER BY s.subject"; |
2818 |
|
|
2819 |
// Fetch the values |
// Fetch the values |
2820 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
2821 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
2822 |
$subject = $row["subject"]; |
$subject = $row["subject"]; |
2823 |
$subject_id = $row["subject_id"]; |
$subject_id = $row["subject_id"]; |
2824 |
printf("<option value = \"%s\">%s</option>\n", $subject_id, $subject); |
printf("<option value = \"%s\">%s</option>\n", $subject_id, $subject); |
2863 |
WHERE |
WHERE |
2864 |
libunit_id = " . $libunit_id; |
libunit_id = " . $libunit_id; |
2865 |
|
|
2866 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
2867 |
$row = mysql_fetch_array($rs); |
$row = xx_fetch_array($rs); |
2868 |
|
|
2869 |
// Fetch values |
// Fetch values |
2870 |
$libunit = Trim($row["libunit"]); |
$libunit = Trim($row["libunit"]); |
3014 |
FROM staff s |
FROM staff s |
3015 |
WHERE s.password IS NOT NULL and staff_id = " . $staff_id; |
WHERE s.password IS NOT NULL and staff_id = " . $staff_id; |
3016 |
|
|
3017 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
3018 |
$row = mysql_fetch_array($rs); |
$row = xx_fetch_array($rs); |
3019 |
|
|
3020 |
// Fetch values |
// Fetch values |
3021 |
$pass_set = Trim($row["pass_set"]); |
$pass_set = Trim($row["pass_set"]); |
3095 |
s.stafftitle_id = t.stafftitle_id AND |
s.stafftitle_id = t.stafftitle_id AND |
3096 |
staff_id=" . $staff_id; |
staff_id=" . $staff_id; |
3097 |
|
|
3098 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
3099 |
$row = mysql_fetch_array($rs); |
$row = xx_fetch_array($rs); |
3100 |
|
|
3101 |
// Fetch results |
// Fetch results |
3102 |
$first_name = Trim($row["first_name"]); |
$first_name = Trim($row["first_name"]); |