query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo '

' . $row["code"]. '

' . $row["name"]. '

' . $row["txt"]. '.

'; } } else { echo "0 results"; } $conn->close(); ?>