Click the button to get a random BName.
connect_error) { die(“Connection failed: ” . $conn->connect_error); } $sql = “SELECT BName FROM PIV_customerInfo ORDER BY RAND() LIMIT 1”; $result = $conn->query($sql); if ($result->num_rows > 0) { $row = $result->fetch_assoc(); echo $row[‘BName’]; } else { echo “No records found”; } $conn->close(); ?>