hello.
can anyone suggest how to view the value using a jump menu.
this is my code that view the data and jump menu.
<?php
session_start();
include_once("conn.php");
if(isset( $_SESSION['username']));
echo "Welcome $_SESSION[username]";
$open=mssql_query("Select * from tblTicket inner join tblAssign on
tblTicket.TickNo=tblAssign.TicketNo where tblAssign.AssignTo='$_SESSION[username]' ");
?>
<html>
<head>
<title>Tikcet Support</title>
<script type="text/javascript">
function OnChange(dropdown){
var myindex = dropdown.selectedIndex
<!--var SelValue = dropdown.options[myindex].value
var baseURL = 'Transfer.php'
top.location.href = baseURL ;<!--+SelValue;
}
</script>
</head>
<body>
<table border='1'>
<tr>
<td>Ticket</td>
<td>User Name</td>
<td>Date</td>
<td>Time</td>
<td>Category</td>
<td>Transfer JO</td>
</tr>
<?php
while($row=mssql_fetch_array($open))
{
$Assign=mssql_query("Select * from MISPIC");
?>
<tr>
<td><?php echo "<a href='Ticketmanage.php?id={$row['TickNo']}'>".$row['TickNo']."</a>"?></td>
<td><?php echo $row['UserName']?></td>
<td><?php echo $row['DateCreate']?> </td>
<td><?php echo $row['TimeCreate']?> </td>
<td><?php echo $row['Category']." (".$row['Subcat'].")"?></td>
<td>
<?php
echo "<form name='test' action='Transfer.php' method='post'>";
echo "<select name='selectBox' id='selectBox' onchange='OnChange(this.form.selectBox);'>";
echo "<option selected>Please Select";
while($row3=mssql_fetch_assoc($Assign)){
echo"<option value='$row3[MISPIC]'>$row3[MISPIC]</option>";
}echo "</select>";
echo "</form>";
$_SESSION[AssingTo]=$row3[MISPIC];
$_SESSION[AssingNo]=$row['TickNo'];
?>
</td>
</tr>
<?php
}
?>
</table>
<a href='Support.php'>Back</a>
</body>
</html>
and this is the page where the jump menu must view the data.
<?php
session_start();
if(isset( $_SESSION['username']));
echo "Welcome $_SESSION[username]";
echo $_SESSION[AssingTo]."<br>";
echo $_SESSION[AssingNo];
include_once("conn.php");
$Pic=mssql_query("Select * from tblPIC");
$attach=mssql_query("Select * from tblTicket
inner join tblAttachment
on tblTicket.TickNo=tblattachment.TicketNo
inner join tblAssign
on tblTicket.TickNo=tblAssign.TicketNo where tblAssign.TicketNo='$_SESSION[AssingNo]'");
$msg1=mssql_query("Select * from tblTicket
inner join tblForum
on tblForum.TicketNo=tblTicket.TickNo
inner join tblAssign
on tblTicket.TickNo=tblAssign.TicketNo and tblTicket.UserName=tblAssign.CreateBy");
while($row=mssql_fetch_assoc($attach)){
$Cday=$row['DateCreate'];
$Cat=$row['Category'];
$SubCat=$row['Subcat'];
$Ttime=$row['TimeCreate'];
$image1=trim($row['image1']);
$image2=trim($row['image2']);
$image3=trim($row['image3']);
$desc=$row['Description'];
$uname=$row['UserName'];
$email=$row['Email'];
$dept=$row['Dept'];
$id=$row['TickNo'];
$pic=$row['PIC'];
}
?>
<html>
<head>
<Title>Transfer Ticket</title>
</head>
<body>
<body>
 
<center>
<table border=1>
<tr>
<td><b>Date:</b></td><td><?php echo $Cday?></td>
<td><b>Time:</b><td><?php echo $Ttime?><td>
</tr>
<tr>
<td><b>Ticket Number:</b></td><td><?php echo$id ?></td>
<td><b>Category:</b><td><?php echo $Cat?></td>
</tr>
<tr>
<td><b>User Name:</b></td><td><?php echo $uname?></td>
<td><b>Sub-Category:</b></td><td><?php echo $SubCat?></td>
</tr>
<tr>
<td><b>Department:</b></td><td><?php echo $dept?></td>
<td><b>Email:</b></td><td><?php echo $email?></td>
</tr>
<tr>
<td><b>PIC:</b></td><td><?php echo $pic?></td>
<td><b>Transfer To:</b></td> </td>
</tr>
<tr>
<td><b>Attachment:</b></td>
<td>
<?php
if(!empty($image1))
{
echo "<a href='DLfile.php?download_file=$image1'>File 1</a>  ";
}
if(!empty($image2))
{
echo "<a href='DLfile.php?download_file=$image2'>File 2</a>  ";
}
if(!empty($image3))
{
echo "<a href='DLfile.php?download_file=$image3'>File 3</a>  ";
}
?>
</td>
</tr>
<tr>
<td><b>Description:</b></td><td><?php echo $desc?></td>
</tr>
</table>
<message>
<?php while($row1=mssql_fetch_array($msg1)){
echo "<br>";
?>
<tr align='left'>
<td align='left'><b><?php echo $row1['MessageBy'].":"?></b></td>
<td align='left'><?php echo $row1['Message']?></td>
</tr>
<?php
}
?>
</message>
</br>
<table frame='box' align='center'>
<th>Add Comments/Solution:</th>
<tr>
<td>
<textarea wrap='physical' name='msg' cols='50' rows='10'>
</textarea>
</td>
</tr>
<td align='center'>
<input type='submit' value='Submit' name='Save'>
<a href='manage.php'>Back</a>
</td>
</td>
</table>
</body>
</html>