viewnote.php

<?php 
// GiftWeb: PHP/PostgreSQL online Gift Registry System 
// Matthew T. Jachimstal
// Copyright (C) 2000-2008  Matthew T. Jachimstal
//
// email: matthew@jachimstal.com
//
// Snail mail: Matthew Jachimstal
//             1106 Canterbury Ct, Unit D
//             Elgin, IL 60120
//
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
//
//
require "./main.inc";
require "./util.php";

$s = $_COOKIE["GiftWeb_Session"];

$i = $_GET["i"];

$conn = ADONewConnection('postgres');
$conn->PConnect($dbhost, $dbuser, $dbpass, $dbname);

$uid = validatesession($s);


$sql = "SELECT * FROM items where item_num='$i'";
$result = $conn->Execute($sql);

if(!$result)
{
	print $conn->ErrorMsg();
}
else
{
	if($result->RecordCount() != 1)
	{
		echo "<h2>An error has occured selecting the item notes.</h2>";
		exit(0);
	}
	else
	{
		$desc = $result->fields["description"];
	}
}

startpage_old("Item notes for $desc", -2);
echo "<h4>Item notes for $desc</h4>";

$result2 = $conn->Execute("SELECT * FROM notes WHERE item_num='$i'");

if (!$result2)
{
	print $conn->ErrorMsg();
}
else
{
	$note = $result2->fields["notes"];
}

?>
<table>
<tr><td width=50%><?php echo $note?></td>
	<td width=50%>&nbsp;</td></tr>
</table>

<p>
<A HREF="" onClick="self.close()">Close this window.</A>



<?php 
    endpage_old(0);
?>