\n";
$zALPHA="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";
$ALPHA=explode(",",$zALPHA);
$AlphaList="";
for ($i=0;$i < count($ALPHA);$i++) {
$xalpha=$ALPHA[$i];
if ($xalpha==$letter) {
$thisletter="
$xalpha";
} else {
$thisletter="
$xalpha";
}
$AlphaList.="
$thisletter\n";
}
echo $AlphaList;
echo "\n";
$mypage->OpenTable();
$qry = "SELECT subject,id from sagovsubs where substring(subject,1,1)='$letter' order by subject";
$result= mysqli_query($conn,$qry) or die(mysqli_error($conn));
$aSubj=array();
while ($row = mysqli_fetch_row($result)) {
$INFO="";
$thisSubject=$row[0];
$thisID=$row[1];
$pos = strpos($thisSubject, "See:");
if ($pos !== false) {
$aSee=explode(":",$thisSubject);
$seeRef=trim($aSee[1]);
$seeOne=trim($aSee[0]);
$xquery="select id from sagovsubs where subject='$seeRef'";
$xresult=mysqli_query($conn,$xquery);
if (mysqli_num_rows($xresult) > 0) {
$xrow=mysqli_fetch_row($xresult);
$xID=$xrow[0];
$letter=substr($seeRef,0,1);
$seeRef="
$seeRef";
$thisSubject=$seeOne.":".$seeRef;
$mypage->TROut("$thisSubject^");
} else {
$mypage->TROut("$thisSubject^");
}
} else {
$INFO=$thisSubject;
}
$query = "SELECT id, title,url,description FROM sagovpubs where subjid=$thisID order by title";
$result2=mysqli_query($conn,$query) or die(mysqli_error($conn));
$tot=mysqli_num_rows($result);
if ($tot > 0) {
$mypage->TROut("$INFO^");
}
while($row2 = mysqli_fetch_row($result2)) {
$range="";
$title=stripslashes(trim($row2[1]));
$url=stripslashes(trim($row2[2]));
$description="
".stripslashes(trim($row2[3]));
$title="
$title";
$mypage->TROut("$title $description");
}
}
$mypage->CloseTable();
?>