query($sql); $brokers = []; if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $brokers[] = $row; // Store each broker's data in an array } } else { $brokers = []; } $conn->close(); ?>