mssql_num_fields(3) php man page | unix.com

MSSQL_NUM_FIELDS(3)													       MSSQL_NUM_FIELDS(3)

mssql_num_fields - Gets the number of fields in result

SYNOPSIS
       int mssql_num_fields (resource  $result)

DESCRIPTION
       mssql_num_fields(3) returns the number of fields in a result set.

PARAMETERS
	      o $result
		- The result resource that is being evaluated. This result comes from a call to mssql_query(3).

RETURN VALUES
	Returns the number of fields, as an integer.

EXAMPLES
       Example #1

	      mssql_num_fields(3) example

	      <?php
	      // Connect to MSSQL and select the database
	      $link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');
	      mssql_select_db('php', $link);

	      // Select some data from our database
	      $data = mssql_query('SELECT [name], [age] FROM [php].[dbo].[persons]');

	      // Construct a table
	      echo '<table border="1">';

	      $header = false;

	      // Iterate through returned results
	      while ($row = mssql_fetch_array($data)) {
		  // Build the table header
		  if (!$header) {
		      echo '<thead>';
		      echo '<tr>';

		      for ($i = 1; ($i + 1) <= mssql_num_fields($data); ++$i) {
			  echo '<td>' . ucfirst($row[$i]) . '</td>';
		      }

		      echo '</tr>';
		      echo '</thead>';
		      echo '<tbody>';

		      $header = true;
		  }

		  // Build the row
		  echo '<tr>';

		  foreach($row as $value) {
		      echo '<td>' . $value . '</td>';
		  }

		  echo '</tr>';
	      }

	      // Close table
	      echo '</tbody>';
	      echo '</table>';

	      // Clean up
	      mssql_free_result($data);
	      mssql_close($link);
	      ?>

SEE ALSO
       mssql_query(3), mssql_fetch_field(3), mssql_num_rows(3).

PHP Documentation Group 												       MSSQL_NUM_FIELDS(3)