57 |
FROM mastersubject |
FROM mastersubject |
58 |
ORDER BY mastersubject"; |
ORDER BY mastersubject"; |
59 |
|
|
60 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
61 |
|
|
62 |
// Initialize counter |
// Initialize counter |
63 |
$rowcount = 0; |
$rowcount = 0; |
64 |
|
|
65 |
// Cycle through the result set |
// Cycle through the result set |
66 |
while ( $row = mysql_fetch_array ( $rs ) ) { |
while ( $row = xx_fetch_array ( $rs ) ) { |
67 |
$mastersubject_id = Trim($row["mastersubject_id"]); |
$mastersubject_id = Trim($row["mastersubject_id"]); |
68 |
$mastersubject = Trim($row["mastersubject"]); |
$mastersubject = Trim($row["mastersubject"]); |
69 |
|
|
89 |
. $mastersubject_id |
. $mastersubject_id |
90 |
. " ORDER BY m.masterinfotype, i.infotype"; |
. " ORDER BY m.masterinfotype, i.infotype"; |
91 |
|
|
92 |
$sub_rs = mysql_query($sub_sql, $con); |
$sub_rs = xx_query($sub_sql, $con); |
93 |
$sub_rowcount = 0; |
$sub_rowcount = 0; |
94 |
|
|
95 |
// Cycle through the result set |
// Cycle through the result set |
96 |
while ( $sub_row = mysql_fetch_array ( $sub_rs ) ) { |
while ( $sub_row = xx_fetch_array ( $sub_rs ) ) { |
97 |
$masterinfotype = Trim($sub_row["masterinfotype"]); |
$masterinfotype = Trim($sub_row["masterinfotype"]); |
98 |
$infotype = Trim($sub_row["infotype"]); |
$infotype = Trim($sub_row["infotype"]); |
99 |
|
|