<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>PHP ODBC Test</title> </head> <body> <?php echo "PHP Omnidex OBDC Simple Select"; $conn=odbc_connect('OdxSystemTest','',''); // had to use system datasource if (!$conn) {exit("Connection Failed: " . $conn);} $sql="SELECT * FROM table1"; $rs=odbc_exec($conn,$sql); if (!$rs) {exit("Error in SQL");} echo "<table><tr>"; echo "<th>MYSEQ</th>"; echo "<th>MYTEXT</th></tr>"; while (odbc_fetch_row($rs)) { $myseq=odbc_result($rs,"MYSEQ"); $mytext=odbc_result($rs,"MYTEXT"); echo "<tr><td>$myseq</td>"; echo "<td>$mytext</td></tr>"; } odbc_close($conn); echo "</table>"; ?> </body> </html>