"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 .=""; $display_ticket .=""; $display_ticket .=""; $display_ticket .=""; $display_ticket .=""; $display_ticket .=" "; $display_ticket .=""; while ($sql_ticket_rows = mysql_fetch_array($sql_ticket_result, MYSQL_ASSOC)) { $display_ticket .=""; $display_ticket .=""; if($sql_ticket_rows["ticket_flag"]==0) $display_ticket .=""; else if($sql_ticket_rows["ticket_flag"]==1) $display_ticket .=""; $ticket_flag = $sql_ticket_rows[ticket_flag]; $display_ticket .=""; $display_ticket .=""; } $display_ticket .="
Ticket idTicket subjectTicket status
$sql_ticket_rows[ticket_id]".stripslashes($sql_ticket_rows[ticket_subject])."".stripslashes($sql_ticket_rows[ticket_subject])."$tickets[$ticket_flag]
"; }else{ $display_ticket .=""; $display_ticket .=""; $display_ticket .=""; $display_ticket .=""; $display_ticket .=""; $display_ticket .=""; $display_ticket .="
No Records  
"; } } ?> Help Desk
 
 
Ticket Status  
   
Email:
Ticket Key: