<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>


[[add|Add another item]]