<%
$link_ID=mysql_connect("localhost","hkahss");
mysql_select_db("hkahss");
if ($position=='p' and $district=='hk') :
$str="SELECT * FROM final where POSITION='P' and DISTRICT='HK' order by SCHOOL ;";
elseif ($position=='p' and $district=='kln') :
$str="SELECT * FROM final where POSITION='P' and DISTRICT='KLN'order by SCHOOL ;";
elseif ($position=='p' and $district=='nt') :
$str="SELECT * FROM final where POSITION='P' and DISTRICT='NT' order by SCHOOL ;";
elseif ($position=='vp' and $district=='hk') :
$str="SELECT * FROM final where POSITION='VP' and DISTRICT='HK' order by SCHOOL ;";
elseif ($position=='vp' and $district=='kln') :
$str="SELECT * FROM final where POSITION='VP' and DISTRICT='KLN' order by SCHOOL ;";
elseif ($position=='vp' and $district=='nt') :
$str="SELECT * FROM final where POSITION='VP' and DISTRICT='NT' order by SCHOOL ;";
elseif ($position=='p') :
$str="SELECT * FROM final where POSITION='P' order by SCHOOL ;";
else:
$str="SELECT * FROM final where POSITION='VP' order by SCHOOL ;";
endif;
$result=mysql_query($str,$link_ID);
$sn_index = mysql_num_rows($result);
mysql_close($link_ID);
$firstletter=" " ;
for($index=0; $index < $sn_index ; $index++){
$arr[$index]= mysql_fetch_array($result);
};
%>
A | B | C | D | E | F | G | H | I | J | K
| L | M | N | O | P | Q | R | S | T | U | V |
W | X | Y | Z
<%
for ($index=0; $index < $sn_index ;$index++ ){
if ($firstletter==substr($arr[$index][SCHOOL],0,1) ):
$firstletter=substr($arr[$index][SCHOOL],0,1) ;
%>
| |
<%
if ($arr[$index][INTRO]==1) :
echo " ";
echo $arr[$index][SCHOOL];
echo "";
else:
echo $arr[$index][SCHOOL];
endif;
%>
|
|
|
|
<%
else :
$firstletter=substr($arr[$index][SCHOOL],0,1) ;
%>
| |
() |
|
|
|
| |
Name
of School |
|
<% if ($position=="vp") : %>
Name
of Vice Principal |
<% elseif ($position=="p") : %>
Name
of Principal |
<% endif ; %>
| |
<%
if ($arr[$index][INTRO]==1) :
echo " ";
echo $arr[$index][SCHOOL];
echo "";
else:
echo $arr[$index][SCHOOL];
endif;
%>
|
|
|
|
<%
endif ;
};
%>
|
<%
if ($district=='') :
echo "
";
elseif ($position=='p' and $district<>'') :
echo "
";
elseif ($position=='vp' and $district<>'') :
echo "
";
endif;
%>
<%
if ($district=='hk') :
echo "
";
elseif ($district<>'hk'and $position=='p') :
echo "
";
elseif ($district<>'hk' and $position=='vp') :
echo "
";
endif ;
%>
<%
if ($district=='kln') :
echo "
";
elseif ($district<>'kln' and $position=='p') :
echo "
";
elseif ($district<>'kln' and $position=='vp') :
echo "
";
endif ;
%>
<%
if ($district=='nt') :
echo "
";
elseif ($district<>'nt' and $position=='p') :
echo "
";
elseif ($district<>'nt' and $position=='vp') :
echo "
";
endif ;
%>
|
