odbc_columns problem with MSSQL
| From: | Christopher Cheng | Date: | Fri, 09 Mar 2001 04:06:12 +0000 |
| Subject: | odbc_columns problem with MSSQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7239@lists.php.net to get a copy of this message | ||
I am trying to get the column names of some tables with odbc_columns from
MSSQL 2000.
As I extract a particular column from the result set, the browser hangs.
<html>
<body>
<?
$con = odbc_connect("mydatabase", "christopher", "");
$result = odbc_columns($con, "mydatabase", "dbo", "dtproperties");
// this works!
odbc_result_all($result);
// but this doesn't.
/*
while (odbc_fetch_row($result))
echo odbc_result($result, COLUMN_NAME);
*/
?>
</body>
</html>