Php outputs data and cannot descPHPcode & lt ;? Php $ SQL = & quot; selectC. id, C. numberfromcargo1Cleftjoincargo2C2onC. number = php output data, 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 );