include("includes/config.php");
include("includes/conn.php");
$tickets = array('0' => "Open",'1' => "Closed",'2' => "Process");
if ($_POST){
$sql_ticket_query = "SELECT * FROM tbl_tickets WHERE ticket_email = '".trim($email)."' and ticket_id = '".trim($key)."'";
$sql_ticket_result = mysql_query($sql_ticket_query);
$num_rows = mysql_num_rows($sql_ticket_result);
if ($num_rows>0){
session_name("helpdesk_user");
session_start();
$_SESSION['email'] = $email;
$display_ticket .="
";
$display_ticket .="";
$display_ticket .="Ticket id | ";
$display_ticket .="Ticket subject | ";
$display_ticket .="Ticket status | ";
$display_ticket .="
";
$display_ticket .="";
$display_ticket .="
| ";
$display_ticket .="
";
while ($sql_ticket_rows = mysql_fetch_array($sql_ticket_result, MYSQL_ASSOC)) {
$display_ticket .="";
$display_ticket .="$sql_ticket_rows[ticket_id] | ";
if($sql_ticket_rows["ticket_flag"]==0)
$display_ticket .="".stripslashes($sql_ticket_rows[ticket_subject])." | ";
else if($sql_ticket_rows["ticket_flag"]==1)
$display_ticket .="".stripslashes($sql_ticket_rows[ticket_subject])." | ";
$ticket_flag = $sql_ticket_rows[ticket_flag];
$display_ticket .="$tickets[$ticket_flag] | ";
$display_ticket .="
";
}
$display_ticket .="
";
}else{
$display_ticket .="