<!--html-->
<?php
    // Get connection
    $DSN="USER";
    $User = "USER";
    $Password = "Password";


    $Conn = odbc_connect($DSN, $User, $Password);

    // Test connection
    if (!$Conn)
    {
      exit ("ODBC Connection Failed: " . $Conn);
    }
    // Create SQL statement
    $SQL = "SELECT LastName, FirstName, Nationality FROM ARTIST";

    // Execute SQL statement
    $RecordSet = odbc_exec($Conn,$SQL);

    // Test existence of RecordSet
    if (!$RecordSet)
      {
        exit("SQL Statement Error: " . $SQL);
      }
?>
<!--html-->
<?php
  // Table headers
  $RecordSetRow = array("LastName" => $row['LastName'],
                        "FirstName" => $row['FirstName]'],
                        "Nationality" => $row['Nationality']);
  // Table data

  while($RecordSetRow = odbc_fetch_array($RecordSet))
    {
    echo '<td>', $RecordSetRow['LastName'], '</td>
          <td>', $RecordSetRow['FirstName'], '</td>'
          '<td>', $RecordSetRow['Nationality'], '</td>';
    }
    echo '</tr></table>';
    // Close connection
    odbc_close($Conn);
?>
<!--html-->