$servername = 'servername';

$username = 'username';

$password = 'password';

$SQL = mysql_connect($servername, $username, $password);


$queryNumber = $_GET['query'];

switch ($queryNumber) {
  case "q1":

    echo "<p>Query 1</p>";

$_GET['facility'];

    echo "<p id='sql'>".$SQL."</p>";
    echo "<table>";
    echo "   <th>Carpark</th>";
    $result = "SELECT nearbyfacilities, campus FROM CarPark"; // names of columns in my database
    while ( $db_field = mysql_fetch_assoc($result) ) {
        echo "<tr><td>" . $db_field['carpark'] . "</tr></td>";
      }
?>