<php>
include(“/var/www/html/greenbox/sqlconnect.php”); include(“/var/www/html/greenbox/sqlconnect2.php”);
$query = “INSERT INTO Items (Year,Type,Freq,Class,Description,Comments,SAN,Contributor,Email,MoreInfoURL,Cell) VALUES ('$_POST[Year]','$_POST[Type]','$_POST[Freq]','$_POST[Class]','$_POST[Description]','$_POST[Comments]','$_POST[SAN]','$_POST[Contributor]','$_POST[Email]','$_POST[MoreInfoURL]','$_POST[Cell]')”;
$result = mysql_query($query)
or die ("Couldn't execute query.");
echo "The following item has been added to the database:<br>
<ul>
<li>Type: $_POST[Type]
<li>Frequency: $_POST[Freq]
<li>Class: $_POST[Class]
<li><b> $_POST[Description] </b> $_POST[Comments]
<li>SAN penalty: $_POST[SAN]
<li>Contributed by: $_POST[Contributor] $_POST[Email]
<li>More info from: $_POST[MoreInfoURL]
<li>Cell $_POST[Cell] available from $_POST[Year]
\n“;
echo "</ul>";
</php>
