Hi,
Is there a way to view a data in database that is equal to my session name
if(mssql_num_rows(mssql_query("Select * from tblAssign where AssignTo='$_SESSION[username]'"))>0){
echo "not viewing my assig ticket";
while($pendticket = mssql_fetch_array($selectTicketsQuery)){
$pendtickets[] = $pendticket;
}
}else{
$selectTicketsQuery = mssql_query("Select * from tblTicket inner join tblAssign on tblTicket.TickNo=tblAssign.TicketNo where tblTicket.Status='Open'");
while($pendticket = mssql_fetch_array($selectTicketsQuery)){
$pendtickets[] = $pendticket;
}