easy way of outputting data to HTML table from a generic recordset?

dgr

i have a series of queries that will return a recordset from a MS SQl 2000 database.

The question is: given i will not know the field names, but will know there will be at least 1 field / 1 row, is there a short script that will give me table headings as per field names and rows output in the table as per the recordset?

THANKS IN ADVANCE!

Regards

dgr

TTT

http://www.php.net/manual/en/ref.msql.php

dgr

the microsoft sql functions (not mSQL) are at:

http://uk.php.net/manual/en/ref.mssql.php

unfortunately it doesn't have the generic script i need, and i can't really think of an easy way of outputting the headings, then the row data - i've always just used


      $result01 = mssql_execute($query01); //execute query01
      while($row01 = mssql_fetch_array($result01)){ //output row data until recordset empty

thanks guys!

dgr