connect();

$stmt = $synverita->prexecute(“SELECT phrase FROM termID WHERE class = ? ORDER BY phrase”, array($_GET[“filterTerms”]));

$synverita->disconnect();

$rows = $stmt->fetchAll(PDO::FETCH_NUM);
foreach ($rows as $row) {
$list[] = ” ‘”.addslashes($row[0]).”‘”;
}
$output = implode(‘,’,$list);

$terms =& $output; //creating variable alias
endif;
?>

connect();

$stmt = $synverita->prexecute(“SELECT n.rank, t.phrase, t.class, n.score FROM (SELECT n.rank, n.neighborID, n.score FROM neighbors_208 as n, (SELECT * FROM termID WHERE phrase = ?) AS f WHERE n.id = f.id) AS n, termID as t WHERE n.neighborID = t.id”, array($_GET[“id”]));

$id_type = $synverita->prexecute(“SELECT class FROM termID WHERE phrase = ?”, array($_GET[“id”]));
$synverita->disconnect();
?>

fetch(PDO::FETCH_ASSOC)[“class”];
?>

Result

Term “” is of class ““
The following are the top rowCount() ?> closest terms to

rowCount() . ” rows returned”;
if($stmt->rowCount() != 0):
?>

setFetchMode(PDO::FETCH_ASSOC);
//foreach(new TableRows(
// new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) {
// echo $v;
//}
while($row = $stmt->fetch(PDO::FETCH_NUM)) {
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

echo “

“;
}
?>

Rank	Neighbor	Class of neighbor	Score	Resources
” . $row[0] . “	” . $row[1] . “	” . $row[2] . “	” . $row[3] . “	” . “” . “” . “” . “

End