Review the PHP code snippet below, and mark / debug / fix the errors and/or inefficiencies that you can find.

<? include 'db.php';

$db = pg_connect('host=$hostname port=$port dbname=$db user=$username');

$date = new DateTime(); $date = $date->format('d M Y'); $time = $date->format('H:i:s');

if (! $db) { echo "Connection failed: ", $db->pg_last_error(); };

$result = pg_query($db, "SELECT queue_name, COUNT(*) FROM messages WHERE id = " . $_GET['id'] . "GROUP BY queue name");

if (! $result) { die("Query error: ", $db->pg_last_error()); }

$records = 0; $queue = array(); $summary = array();

while ($row = pg_fetch_row($result)) { list ($site, $name) = explode('_', $row);

if (! isset ($queue[$site])) {
  $queue[$site] = array();
}

if (isset ($queue[$site][$name])) {
  $queue[$site][$name] = 0;
}

$queue[$site][$name]++;
}

// Print the result in table echo '<table>' . '<tr>' . '<td>Site</td>' . '<td>Name</td>' . '<td>Count</td>'; foreach ($queue as $outer) { foreach ($outer as $count) { echo "<tr>"; echo "<td>$queue[$site]</td>"; echo "<td>$queue[$name]</td>"; echo "<td>$count</td>"; echo "</tr>"; } }