title: Why do I get an internal server error from my SQL query?
body: <p>I am attempting to retrieve some data from my database, I appear to be able to connect to the database as I do not get an error message after the connection is tested. But when I attempt to run a select query, it causes an internal error.</p>
  
  <p>If I take the FROM part away from the query, the page loads with no data. If I add the FROM part back in, with the table to be selected from, the internal error occurs.</p>
  
  <p>The code is below:</p>
  
  <pre><code>$con = mysqli_connect("50.62.209.87:3306","myusername","mypassword",
  "FiveExtras");
  // Check connection
  if (mysqli_connect_errno())
    {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
  
       $query = "SELECT `EventVenue`,`EventDate`,`EventTime`,
       `EventPostCode` FROM `event`";
  
    $result = mysqli_query($con, $query);
  
  
  $row = $result;
  
  echo $row;
  </code></pre>