<?
//Basmati -- Version 2.0P
//Copyright 2000, James B. Bassett (hide@address.com)
//All rights reserved. Please read enclosed license.
//Module: showteachermemo.php
include("../main.inc.php");
list($ulvl, $loggedin) = check_auth();
if(($ulvl < 10)){
print_header("Error");
echo "Sorry You Do Not have a High Enough User Level to use this page";
print_footer();
exit;
}
print_header("Gradebook:Edit Row");
include ("basmaticonstants.php");
//Pull existing contents from database
$sql_query = "SELECT webinfo, webinfodate FROM CLIENTS WHERE client_id = '" . $TchrUserID . "'";
$mysql_query = "SELECT webinfo, webinfodate FROM CLIENTS WHERE client_id = '" . $TchrUserID . "'";
if ($datamethod == "odbc"){
$link = odbc_connect($databasename,$datausername,$datapassword);
$sql_statement = odbc_prepare($link,$sql_query);
$sql_result = odbc_execute($sql_statement);
$sql_result = mysql_query($mysql_query,$db);
echo mysql_error($link);
if (mysql_num_rows($sql_result)!=0){
$nfields = mysql_num_fields($sql_result);
while (mysql_fetch_row($sql_result)){
$nrows++;
for ($i=0;$i<$nfields;$i++){
$ary[$nrows][$i+1] = mysql_result($sql_result,$nrows-1,$i);
} // for
} //while
$commenttext = $ary[1][1];
$commentdate = $ary[1][2];
mysql_free_result($sql_result);
}//If numrows != 0
echo ("<i><font size=+1>$Namesake submitted the following comments on $commentdate...</font></i><hr><pre>");
echo (stripslashes(stripslashes($commenttext)));
echo ("</pre><br>");
print_footer();
?>