Help in SQL Query

PHP
1

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;
		}
2

If the IF is true, you try to loop through $selectTicketsQuery, but you never assigned a query result set to that variable.

3

yeah…that’s what i figure out…it solved the my problem.