query($query)) { // $result: The mysqli_result class echo "\n"; echo "\n"; /* Fetch results */ while ( $row = $result->fetch_assoc() ){ echo "\n"; } echo "

SNum	Supplier Name	City	Status
" . $row['snum'] . "	" . $row['sname'] . "	" . $row['scity'] . "	" . $row['status'] . "

\n"; /* Destroy the result set and free the memory used for it */ $result->close(); } // [4] Housekeeping. $mysqli->close(); ?>