<?php include ("includes/db.php"); $id = $_GET['id']; $process = $_POST['process']; $table_name2 = "baccount"; $connection = @mysql_connect($localhost, $dbuser, $dbpass) or die ("Couldn't Connect to database"); $db = @mysql_select_db($dbname, $connection) or die("Couldn't select database"); $sql = "select * from $table_name2 WHERE id = '$id'"; $result = @mysql_query($sql,$connection) or die ("Couldn't execute query"); while ($row = mysql_fetch_array($result)) { $awards_text = $row["awards_text"]; $free_text = $row["free_text"]; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>foodplanet infonet</title> <link href="includes/default.css" rel="stylesheet" type="text/css" /> </head> <script> self.resizeTo(700,600); self.moveTo(700,350); </script> <body> <div id="extra">Classifications (<?php echo ''.$id.''; ?>)</div> <div id="extra1"><form id="form1" name="form1" method="post" action="extratext2.php"> <table width="100%" border="0"> <tr> <td><strong>More Information</strong></td> </tr> <tr> <td><label> <textarea name="free_text" cols="60" rows="5" wrap="physical" id="free_text"><?php echo ''.$free_text.''; ?> </textarea> </label></td> </tr> <tr> <td><strong>Award Text </strong></td> </tr> <tr> <td><label> <textarea name="awards_text" cols="60" rows="5" wrap="physical" id="awards_text"><?php echo ''.$awards_text.''; ?> </textarea> </label></td> </tr> <tr> <td><label> <div align="center"> <input type="submit" name="Submit" value="Save" /> <input name="id2" type="hidden" id="id2" value="<?php echo ''.$id.'';?>" /> <input name="process" type="hidden" id="process" value="1" /> </div> </label></td> </tr> </table> </form><br /><a href="Javascript: self.close()">Close Window</a> </div> </body> </html>
