alert('Please fill all required fields');"; } else { // Construct SQL query $query = "INSERT INTO Matches (match_date, home_team_id, away_team_id, result, venue_id) VALUES('$match_date', '$home_team_id', '$away_team_id', '$result', '$venue_id')"; // Execute SQL query $result = mysqli_query($conn, $query); // Check for query execution success if ($result) { echo ""; header('location:matches.php'); } else { echo ""; echo "Error: " . mysqli_error($conn); } } } // Retrieve teams and venues for dropdowns $query_teams = "SELECT team_id, team_name FROM Team"; $result_teams = mysqli_query($conn, $query_teams); $query_venues = "SELECT venue_id, venue_name FROM Venue"; $result_venues = mysqli_query($conn, $query_venues); ?> Insert Match
MATCH DETAILS INSERTION

Match