function q5()
{
$dao = new DAO();
$q = "SELECT USERID FROM Q5 WHERE NUM = (SELECT MAX(NUM) FROM Q5)";
$stmt = oci_parse($dao->con, $q);
oci_execute($stmt, OCI_DEFAULT);
oci_fetch_all($stmt, $rs);
foreach ($rs as $rows) {
echo "";
foreach ($rows as $col_values) {
echo "User contributed most reviews: " . $dao->fetchUserName($col_values) . '<br>';
}
}
oci_free_statement($stmt);
$q = "SELECT USERID FROM Q5 WHERE NUM = (SELECT MAX(NUM) FROM Q5)";
$stmt = oci_parse($dao->con, $q);
oci_execute($stmt, OCI_DEFAULT);
oci_fetch_all($stmt, $rs);
foreach ($rs as $rows) {
echo "";
foreach ($rows as $col_values) {
echo "User contributed most comments on threads: " . $dao->fetchUserName($col_values) . '<br>';
}
}
}
function displayFollowUp()
{
$dao = new DAO();
$rs = $dao->fetchFollowUpIDs($_GET['tid']);
foreach ($rs as $rows) {
foreach ($rows as $value) {
echo '<div class="container">';
echo '<p> To:' . $dao->fetchThreadName($value) . '  Reply By ' . $dao->fetchUserName($dao->fetchUserIDByThreadID($value)) . '<br>' . $dao->fetchThreadContent($value) . '</p>';
echo '</div>';
}
}
}
function displayGuestInfo()
{
$dao = new DAO();
$rs = $dao->fetchGuestList();
echo 'Avalible Guest to View: <br>';
echo '<table border=0>';
foreach ($rs as $row) {
foreach ($row as $id) {
echo '<tr>';
$loginName = $dao->fetchLoginName($id);
$changeLink = "<a href=\"account.php?loginName={$loginName}\">" . 'view' . '</a>';
echo '<td> Guest: ' . $dao->fetchUserName($id) . '</td><td> ' . $changeLink . '</td><td>';
echo '</tr>';
}
}
echo '</table>';
}
