ID Stock Name Sector Price Price Date‘; if ($result = $mysqli->query($query)) { while ($row = $result->fetch_assoc()) { $field1name = $row[“id”]; $field2name = $row[“stockname”]; $field3name = $row[“sector”]; $field4name = $row[“price”]; $field5name = $row[“pricedate”]; echo ‘‘.$field1name.’‘.$field2name.’‘.$field3name.’‘.$field4name.’‘.$field5name.’‘; } $result->free(); } ?>