mssql_num_rows(3) [php man page]

MSSQL_NUM_ROWS(3)														 MSSQL_NUM_ROWS(3)

mssql_num_rows - Gets the number of rows in result

SYNOPSIS

       int mssql_num_rows (resource  $result)

DESCRIPTION

       mssql_num_rows(3) returns the number of rows 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 rows, as an integer.

EXAMPLES

       Example #1

	      mssql_num_rows(3) example

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

	      // Select all our records from a table
	      $query = mssql_query('SELECT * FROM [php].[dbo].[persons]');

	      echo 'Total records in database: ' . mssql_num_rows($query);

	      // Clean up
	      mssql_free_result($query);
	      ?>

SEE ALSO

       mssql_query(3), mssql_fetch_row(3).

PHP Documentation Group 													 MSSQL_NUM_ROWS(3)

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)