odbc_fetch_row(3) [php man page]

ODBC_FETCH_ROW(3)							 1							 ODBC_FETCH_ROW(3)

odbc_fetch_row - Fetch a row

SYNOPSIS

       bool odbc_fetch_row (resource  $result_id, [int	$row_number])

DESCRIPTION

	Fetches  a  row of the data that was returned by odbc_do(3) or odbc_exec(3). After odbc_fetch_row(3) is called, the fields of that row can
       be accessed with odbc_result(3).

PARAMETERS

	      o $result_id
		- The result identifier.

	      o $row_number
		- If $row_number is not specified, odbc_fetch_row(3) will try to fetch the next row in the result set. Calls to  odbc_fetch_row(3)
		with  and  without  $row_number  can  be  mixed.   To  step through the result more than once, you can call odbc_fetch_row(3) with
		$row_number 1, and then continue doing odbc_fetch_row(3) without $row_number to review the result. If  a  driver  doesn't  support
		fetching rows by number, the $row_number parameter is ignored.

RETURN VALUES

	Returns TRUE if there was a row, FALSE otherwise.

PHP Documentation Group 													 ODBC_FETCH_ROW(3)

MSSQL_DATA_SEEK(3)														MSSQL_DATA_SEEK(3)

mssql_data_seek - Moves internal row pointer

SYNOPSIS

       bool mssql_data_seek (resource  $result_identifier, int	$row_number)

DESCRIPTION

       mssql_data_seek(3)  moves  the  internal  row  pointer of the MS SQL result associated with the specified result identifier to point to the
       specified row number, first row being number 0. The next call to mssql_fetch_row(3) would return that row.

PARAMETERS

	      o $result_identifier
		- The result resource that is being evaluated.

	      o $row_number
		- The desired row number of the new result pointer.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      mssql_data_seek(3) example

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

	      // Select all people
	      $result = mssql_query('SELECT [name], [age] FROM [persons] WHERE [age] >= 13');

	      if (!$result) {
		  die('Query failed.');
	      }

	      // Select every 4th student in the results
	      for ($i = mssql_num_rows($result) - 1; $i % 4; $i++) {
		  if (!mssql_data_seek($result, $i)) {
		      continue;
		  }

		  // Fetch the row ...
	      }

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

PHP Documentation Group 													MSSQL_DATA_SEEK(3)