You need to have a 1 to 1 row to row and 1 to 1 cell to cell
<?php
$sql = "SELECT local_name FROM storms";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) { ?>
<tr>
<td><?= $row["name"] ?></td>
<td><?= $row["local_name"] ?></td>
....
</tr>
<? }
} ?>
solved Why is my HTML table not showing properly? [closed]