How to get recharge response status in XML format and checking mobile no is allocated to someone or not using PHP

db_query("SELECT * FROM #_stock WHERE `msisdn`='".$mobileno."' and ");
  $find_mobile_number_query = $BSC->db_query("SELECT * FROM #_stock WHERE `msisdn`=".$mobileno." and `over_partners` = 2 and `sim_type` = 'Pre Paid' and `typez` = 'presim' and `sim_status` = 'Active'");
  
          //$caf_result = $BSC->db_fetch_array($find_mobile_number_query);
$rss_txt = '';
$rss_txt .= '';
    //echo $find_mobile_number_query;
    $find =  mysql_num_rows($find_mobile_number_query);
     //echo $find;
   if($find > 0)
   {
          $lstatus = $BSC->getSingleresult("select lstatus from #_stock WHERE `msisdn`=".$mobileno."");
          if($lstatus=='Challaned Out')
       {
        $userid = $BSC->getSingleresult("select userid from #_stock WHERE `msisdn`=".$mobileno."");
        $userid_info = $BSC->db_query("select fname, lname, email from #_member WHERE `pid`=".$userid."");
        $userid_result = $BSC->db_fetch_array($userid_info);
        $status = 1;
             $rss_txt .= '' .$status. '';
                            $rss_txt .= '' .$userid_result[0]. '';            
                            $rss_txt .= '' .$userid_result[1]. '';
       $rss_txt .= '' .$userid_result[2]. '';
       
        // echo "Executive name: ".$userid_result[0]." ".$userid_result[1].",
 Email Id: ".$userid_result[2];
       }
         
         else if($lstatus=='Customer')
       {
        $ltrans = $BSC->getSingleresult("select ltrans from #_stock WHERE `msisdn`=".$mobileno."");
        $cafid_info = $BSC->db_query("select fname, lname, email from #_member WHERE `cafid`=".$ltrans."");
        $cafid_info_result = $BSC->db_fetch_array($cafid_info);
        $status = 1;
             $rss_txt .= '' .$status. '';
             $rss_txt .= '' .$cafid_info_result[0]. '';            
                            $rss_txt .= '' .$cafid_info_result[1]. '';
       $rss_txt .= '' .$cafid_info_result[2]. '';
        
             //echo "Customer name: ".$cafid_info_result[0]." ".$cafid_info_result[1].",
 Customer Email Id: ".$cafid_info_result[2];
        }
     else{
      
      $status = 0;
               $rss_txt .= '' .$status. '';
     }
   //$status = 1;
   //echo $status."Sim Available";
   }
   else{
   
   $status = 0;
   $rss_txt .= '' .$status. '';
   
   //echo $status."Sim Not Available";
    }

$rss_txt .= '';
$rss_txt .= '';
echo $rss_txt;
    
//SELECT * FROM `owt_stock` WHERE `msisdn` !='' and `over_partners` = 2 and `sim_type` = 'Pre Paid' and `typez` = 'presim' and `sim_status` = 'Active' and (`lstatus`='Customer' || `lstatus`='Challaned Out');
?>

Thanks and Happy Coding...