"; include('misc.inc'); $connection = mysql_connect($host,$user,$password) or die ("couldn't connect to server"); $db = mysql_select_db($database,$connection) or die ("Couldn't select database"); $result = @mysql_query("SELECT * FROM Tapes WHERE tapeType='$_POST[tapetype]'") or die ("Couldn't execute query"); /* $query = "SELECT * FROM Tapes WHERE tapeType='$tapeType'"; $result = mysql_query($query) or die ("Couldn't execute query."); */ echo "

Information for tape type $_POST[tapetype]

\n"; echo "

Please check the information below and change any information that is incorrect.

"; echo "
\n"; // echo ""; /* print "\$_POST[tapetype] = {$_POST[tapetype]}\n
"; */ // Display the Tape Label of each tape in a paragraph // $row[key] while ($row = mysql_fetch_array($result)) { echo ""; } echo "
Key
Tape Label Last Used Current Location Last Location Changed Last Changed
\n"; echo "$row[TapeLabel] $row[LastUsed] $row[CurrentLocation] $row[LastLocation] $row[Changed] $row[LastChanged]

Main Menu

"; /* echo "
echo "First Name
Last Name
Date of Birth Gender Male Female
Email
Address
"; /* $query = "UPDATE MFNFABTapeLog SET tapeType='$row[2]', print "\$query = $query\n
"; $result = mysql_query($query) or die ("Couldn't execute query."); */ ?>