Php outputs data and cannot desc solution-php Tutorial

Php outputs data and cannot descPHPcode & lt ;? Php $ SQL & quot; selectC. id, C. numberfromcargo1Cleftjoincargo2C2onC. numberC2.numberleftjoincargo3C3onC. numberC3.number & quot; php outputs data and cannot desc

PHP code

  
  Query ($ SQL); $ tb = ""; while ($ r = $ q-> fetch_array (MYSQLI_USE_RESULT) {$ tb. ="". $ R [number]."". $ R [shipper]."". $ R [nnne]."". $ R [po]."". $ R [invoice]."". $ R [pol]."". $ R [pod]."            ". $ R [dest]."". $ R [vessel]."". $ R [bookingDate]."". $ R [receivedBooking]."". $ R [confirmSpace]."";}?>
    
  
  
    
   
   
 
    
 
     
Zookeeper
 
     
Outgoing contact
 
    
 
   
    
   
   
  
   
    
   
   
 
    
 
     
Zookeeper
 
     
Outgoing contact
 
    
 
   
  
  

The SQL code is displayed, but the results cannot be obtained. What is the reason? it is correct to execute the statement separately in mysql (desc), that is, if the statement is output through while, it is still asc. why ??

------ Solution --------------------
While ($ r = $ q-> fetch_array (MYSQLI_USE_RESULT ))
MYSQLI_USE_RESULT
------ Solution --------------------
$ R = $ q-> fetch_array (MYSQLI_ASSOC );