mssql_result(3) [php man page]

MSSQL_RESULT(3) 														   MSSQL_RESULT(3)

mssql_result - Get result data

SYNOPSIS

       string mssql_result (resource  $result, int  $row, mixed  $field)

DESCRIPTION

       mssql_result(3) returns the contents of one cell from a MS SQL result set.

PARAMETERS

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

	      o $row
		- The row number.

	      o $field
		-  Can be the field's offset, the field's name or the field's table dot field's name (tablename.fieldname). If the column name has
		been aliased ('select foo as bar from...'), it uses the alias instead of the column name.

	      Note

		      Specifying a numeric offset for the $field argument is much quicker than specifying a fieldname or tablename.fieldname argu-
		     ment.

RETURN VALUES

	Returns the contents of the specified cell.

EXAMPLES

       Example #1

	      mssql_result(3) example

	      <?php
	      // Send a select query to MSSQL
	      $query = mssql_query('SELECT [username] FROM [php].[dbo].[userlist]');

	      // Check if there were any records
	      if (!mssql_num_rows($query)) {
		  echo 'No records found';
	      } else {
		  for ($i = 0; $i < mssql_num_rows($query); ++$i) {
		      echo mssql_result($query, $i, 'username'), PHP_EOL;
		  }
	      }

	      // Free the query result
	      mssql_free_result($query);
	      ?>

	      The above example will output something similar to:

	      Kalle
	      Felipe
	      Emil
	      Ross

       Example #2

	      Faster alternative to above example

	      <?php
	      // Send a select query to MSSQL
	      $query = mssql_query('SELECT [username] FROM [php].[dbo].[userlist]');

	      // Check if there were any records
	      if (!mssql_num_rows($query)) {
		  echo 'No records found';
	      } else {
		  while ($row = mssql_fetch_array($query)) {
		      echo $row['username'], PHP_EOL;
		  }
	      }

	      // Free the query result
	      mssql_free_result($query);
	      ?>

NOTES

       Note

	       When  working  on  large result sets, you should consider using one of the functions that fetch an entire row (specified below). As
	      these functions return the contents of multiple cells in one function call, they're MUCH quicker than mssql_result(3).

SEE ALSO

	Recommended high-performance alternatives: mssql_fetch_row(3), mssql_fetch_array(3), mssql_fetch_assoc(3), mssql_fetch_object(3).

PHP Documentation Group 													   MSSQL_RESULT(3)

Check Out this Related Man Page

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)

Linux and UNIX Man Pages

mssql_result(3) [php man page]

Check Out this Related Man Page