mssql_fetch_row(3) [php man page]

MSSQL_FETCH_ROW(3)														MSSQL_FETCH_ROW(3)

mssql_fetch_row - Get row as enumerated array

SYNOPSIS

       array mssql_fetch_row (resource	$result)

DESCRIPTION

       mssql_fetch_row(3)  fetches  one  row  of  data	from the result associated with the specified result identifier. The row is returned as an
       array. Each result column is stored in an array offset, starting at offset 0.

	Subsequent call to mssql_fetch_row(3) would return the next row in the result set, or FALSE if there are no more rows.

PARAMETERS

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

RETURN VALUES

	Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.

EXAMPLES

       Example #1

	      mssql_fetch_row(3) example

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

	      // Query to execute
	      $query = mssql_query('SELECT [id], [quote] FROM [quotes] WHERE [id] = '42'', $link);

	      // Did the query fail?
	      if (!$query) {
		  die('MSSQL error: ' . mssql_get_last_message());
	      }

	      // Fetch the row
	      $row = mssql_fetch_row($query);

	      // Print the 'quote'
	      echo 'Quote #' . $row[0] . ': "' . $row[1] . '"';
	      ?>

	      The above example will output something similar to:

	      Quote #42: "The answer to everything..."

NOTES

       Note

	      This function sets NULL fields to the PHP NULL value.

SEE ALSO

       mssql_fetch_array(3), mssql_fetch_object(3), mssql_data_seek(3), mssql_result(3).

PHP Documentation Group 													MSSQL_FETCH_ROW(3)

MSSQL_FIELD_SEEK(3)													       MSSQL_FIELD_SEEK(3)

mssql_field_seek - Seeks to the specified field offset

SYNOPSIS

       bool mssql_field_seek (resource	$result, int  $field_offset)

DESCRIPTION

	Seeks to the specified field offset. If the next call to mssql_fetch_field(3) won't include a field offset, this field would be returned.

PARAMETERS

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

	      o $field_offset
		- The field offset, starts at 0.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Using mssql_field_seek(3) on the example for mssql_fetch_field(3)

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

	      // Send a select query to MSSQL
	      $query = mssql_query('SELECT * FROM [php].[dbo].[persons]');

	      // Construct table
	      echo '<h3>Table structure for 'persons'</h3>';
	      echo '<table border="1">';

	      // Table header
	      echo '<thead>';
	      echo '<tr>';
	      echo '<td>Field name</td>';
	      echo '<td>Data type</td>';
	      echo '<td>Max length</td>';
	      echo '</tr>';
	      echo '</thead>';

	      // Dump all fields
	      echo '<tbody>';

	      for ($i = 0; $i < mssql_num_fields($query); ++$i) {
		  // Fetch the field information, notice the
		  // field_offset parameter is not set. See
		  // the mssql_field_seek call below
		  $field = mssql_fetch_field($query);

		  // Print the row
		  echo '<tr>';
		  echo '<td>' . $field->name . '</td>';
		  echo '<td>' . strtoupper($field->type) . '</td>';
		  echo '<td>' . $field->max_length . '</td>';
		  echo '</tr>';

		  // Move the internal seek pointer to the next
		  // row in the result set
		  mssql_field_seek($query, $i + 1);
	      }

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

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

SEE ALSO

       mssql_fetch_field(3).

PHP Documentation Group 												       MSSQL_FIELD_SEEK(3)