——————————————————-
[code=php]<?
session_start();
?>
<html>
<head><title>Ticket System</title>
<script language=”javascript”>
function tkvalid()
{
var frmname=window.document.form1;
if(frmname.servers.value==’0′)
{
alert(“Please select the server ip”);
frmname.servers.focus();
return false;
}
if(frmname.department.value==’0′)
{
alert(“Please select the Department”);
frmname.department.focus();
return false;
}
if(frmname.message.value==””)
{
alert(“Please Enter the message”);
frmname.message.focus();
return false;
}
}
function tkthome()
{
document.location=”customerhome.php”;
}
</script>
</head>
<!–body bgcolor=”lavenderblush”–>
<?
include(“include.php”);
$username=$_SESSION[‘usernam’];
$password=$_SESSION[‘passwrd’];
$query=”select * from server_info where email=’$username'”;
$result=mysql_query($query);
//echo $row->full_name;
?>
<body bgcolor=”seashell”>
<?
echo “<center><b><font face=’verdana’ color=’brown’ size=’4′>Welcome to Ticket System</font></b></center><br>”;
?>
<form method=”post” action=”send_ticket.php” name=”form1″>
<table border=’1′ align=’center’ width=’100%’>
<tr>
<tr>
<td align=”center” colspan=””><font face=’verdana’ color=’black’ size=’2′><b>Submit Trouble Ticket</b></font></td>
</tr>
<tr>
<td align=”center”>
<table border=”1″ align=”center” width=”70%”>
<tr>
<td align=”right” colspan=””><font face=’verdana’ color=’black’ size=’2′>Server IP </font></td>
<td align=”left”><font face=’verdana’ color=’black’ size=’2′>
<select name=”servers” size=”1″>
<option value=”0″>Please Choose</option>
<?
while($row=mysql_fetch_object($result))
{
$serverip=$row->server_ip;
echo “<option value=$serverip>$serverip</option>”;
}
?>
</select>
</font></td>
</tr>
<tr>
<td align=”right”><font face=’verdana’ color=’black’ size=’2′>Department </font></td>
<td align=”left”><font face=’verdana’ color=’black’ size=’2′>
<select name=”department” size=”1″>
<option value=”0″>Please Choose</option>
<?
$query1=”select * from department”;
$result1=mysql_query($query1);
while($row1=mysql_fetch_object($result1))
{
$depart=$row1->dept_name;
echo “<option value=$depart>$depart</option>”;
}
?>
</select></font></td>
</tr>
<tr>
<td align=”right”><font face=’verdana’ color=’black’ size=’2′>Message</font></td>
<td align=”left”><font face=’verdana’ color=’black’ size=’2′><textarea name=”message” rows=”4″ cols=”27″/></textarea></font></td>
</tr>
</table>
</td>
</tr>
<tr><td colspan=””> </td></tr>
<tr>
<td align=”center” colspan=”2″><font face=’verdana’ color=’black’ size=’2′><input type=”button” name=”close” value=”Home” onclick=”tkthome();”> <input type=”submit” name=”submit” value=”submit” onclick=”return tkvalid();”></font></td></tr>
</table>
</form>
<?
if(!isset($_GET[‘msg’]))
{
$msg=””;
}
else if($_GET[‘msg’]==’1′)
{
?>
<table align=”center” border=”0″>
<tr><td align=”center”><font face=’verdana’ color=’red’ size=’2′>
<b>Your Ticket is successfully submitted</b></font></td></tr></table>
<?
}
else if($_GET[‘msg’]==’0′)
{
?>
<table align=”center” border=”0″>
<tr><td align=”center”><font face=’verdana’ color=’red’ size=’2′>
<b>Your Ticket is not successfully submitted</b></font></td></tr></table>
<?
}
?>
—————————
when the user clicks with value “NO” to a field “status” in the table:
how to send & write to afield with value ?
help