SQL SERVER instance 1 connected through ODBC
<?
$ Connection = odbc_connect ("mydata", "userid", "passwd ");
$ Query = "select * from tab_1 where no> 0 ";
$ Result = odbc_do ($ connection, $ query );
Print "<table border = '1' width = '000000' id = 'tab1' cellPadding = '1' cellSpacing = '0' align = 'top' bordercolorlight = '#8080' bordercolordark = '#008000'> ";
While (odbc_fetch_into ($ result, & $ fields ))
{
Print "<tr> \ n ";
For ($ I = 21; $ I <= 31; $ I ++ ){
Print "<td width = '6% '> <input style = 'background-COLOR: # ffffff; BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: # ffffff 1px solid; BORDER-RIGHT: # ffffff 1px solid; BORDER-TOP: # ffffff 1px solid; BORDER-BOTTOM: # ffffff 1px solid; COLOR: #000000; FONT-SIZE: 9pt 'size = '7' type = 'text' name = text $ I value = $ temp> ";
}
}
Print "</table> ";
Odbc_close ($ connection );
?>