Location: PHPKode > projects > Radtracker > radtracker/submitissue.php
<?php
include ("pagefunctions.php");
gentop("Submit Issue");
?>
<h1 align="left">Issue Submission</h1>
<!-----Issue----->
<form method="post" action="addissue.php">
<table align="left" border="1" cellpadding="2" cellspacing="2">
<tr><td>Name:</td><td><input type="text" name="Contact"></td></tr>
<tr><td>Your Email:</td><td> <input type="text" name="Contactemail"></td></tr>
<tr><td>Phone Number:</td><td> <input type="text" name="Contactphone"></td></tr>
<tr><td>Problem Category:</td><td>
<select name="Category" size="1">
<option value="">Choose...</option>
<!-----Read Category----->

<?php
$sql_command = "SELECT Category FROM category ORDER BY Category";
$sql_result = mysql_query($sql_command,$connection) or die (mysql_error());
while ($row = mysql_fetch_array($sql_result)) {
$category = $row["Category"];
echo "<option value=\"$category\">$category</option>";
}

?>
<!------Read Category Over------->
</select></td>
<tr><td>Severity:</td><td>
<select size="1" name="Severity">
  <option value="low">Low</option>
  <option value="medium">Medium</option>
  <option value="high">High</option>
</select></td></tr>
<tr><td>Description:</td></tr>
<tr><td align=middle colspan=2><textarea rows="5" cols="55" wrap="auto" name="Description">
</textarea></td></tr>
<!----Location----->
<tr><td>Area:</td><td>
<select size="1" name="Building">
<option selected value=""></option>
<?php
$sql_command = "SELECT Building FROM building ORDER BY Building";
$sql_result = mysql_query($sql_command,$connection) or die (mysql_error());
while ($row = mysql_fetch_array($sql_result))
	 {
	$building = $row["Building"];
	echo "<option value=\"$building\">$building</option>";
	}
?>
</select></td></tr>
<tr><td>Room:</td><td>
<input type="text" name="Room"></td></tr>
<tr><td>Computer Name or Asset Tag Number</td><td>
<input type="text" name="CompName"></td></tr>
<tr><td>Cost Center: (where applicable)</td><td>
<select size="1" name="costcenter">
<option selected value=""></option>
<?php
$sql_command = "SELECT center FROM costcenter ORDER BY center";
$sql_result = mysql_query($sql_command,$connection) or die (mysql_error());
while ($row = mysql_fetch_array($sql_result))
	 {
	$center = $row["center"];
	echo "<option value=\"$center\">$center</option>";
	}
?>
</select></td></tr>
<tr><td colspan=2 align=middle><input type="submit"></td></tr></table>
<?php
genbottom();
?>
</form>
Return current item: Radtracker