<?
# Show Notes show all information about a Note or indicate no
# records found.  It should present a list of items if none were
# selected.
session_start();

require("quicklyweb.php");
require("security/hybrid.php");

beginDocument($lShowNotes, $_SESSION['sess_user']);

$db = getDBConnection(); 

if ($_GET['NoteID']) {
	$result = DBquery("SELECT * from Notes where NoteID=$_GET[NoteID]", $db);
	$myrow = DBfetch_array($result);
	beginPrettyTable("4", $lNoteDetails);
	makeStaticField($lID, 	$myrow["NoteID"]);
	makeStaticField($lCustomerID, 	$myrow["CustomerID"]);
	makeStaticField($lNote,		$myrow["Note"]);
	makeStaticField($lDatePosted, 	$myrow["PostedDate"]);
	makeStaticField($lPoster, 	$myrow["Poster"]);
	endPrettyTable();
} else {
	beginPrettyTable("1", $lNoteDetails);
	echo $lNoRecords; 
	endPrettyTable();
}
endDocument();
?>