title: Search Results do not display PHP MySql
body: <p>We are trying to do a search form with 7 search criteria for a database with 8 attributes. But we only want to search one event at a time. This is the code I have so far and would like to display the searched information into the table. Any help to know where to look would bee appreciated. </p>
  
  <pre><code>&lt;?php
  include 'database_connector.php';
  if(isset($_POST['submit'])){
   $type = $_POST['type'];
   $team1 = $_POST['team1'];
   $team2 = $_POST['team2'];
   $place = $_POST['place'];
   $year = $_POST['year'];
   $month = $_POST['month'];
   $day = $_POST['day'];
   $price = $_POST['price'];
   $date = $year.'-'.$month.'-'.$day;
    if($type)(
      $result=mysqli_connect($con, "select * from Sports where `Event Type` = '$type'")
      );
  if($team1)(
  $result1=mysqli_connect($con, "select * from Sports where `Team 1` = '$team1'")
  );
  if($team2)(
  $result2=mysqli_connect($con, "select * from Sports where `Team 2` = '$team2'")
  );  
  if($place)(
  $result3=mysqli_connect($con, "select * from Sports where `Place` = '$place'")
  );
  if($date)(
  $result4=mysqli_connect($con, "select * from Sports where `Date` = '$date'")
  );
  if($price)(
  $result5=mysqli_connect($con, "select * from Sports where `Price` = '$price'")
  );
  }
  ?&gt;
  </code></pre>