<?php
$conn = odbc_connect('myDSN','','');
if ($conn) { $query = "select * from cars"; $result=odbc_exec($conn, $query);
echo "<table border=\"1\"><tr>";
$colName = odbc_num_fields($result); for ($j=1; $j<= $colName; $j++) { echo "<th>"; echo odbc_field_name ($result, $j ); echo "</th>"; }
while(odbc_fetch_row($result)) { echo "<tr>"; for($i=1;$i<=odbc_num_fields($result);$i++) { echo "<td>"; echo odbc_result($result,$i); echo "</td>"; } echo "</tr>"; }
echo "</td> </tr>"; echo "</table >";
odbc_close ($conn); } else echo "odbc not connected"; ?> |