query($query)) { 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(); } $mysqli->close(); ?>