ingres_fetch_row(3) [php man page]

INGRES_FETCH_ROW(3)							 1						       INGRES_FETCH_ROW(3)

ingres_fetch_row - Fetch a row of result into an enumerated array

SYNOPSIS

       array ingres_fetch_row (resource  $result)

DESCRIPTION

       ingres_fetch_row(3)  returns an array that corresponds to the fetched row, or FALSE if there are no more rows. Each result column is stored
       in an array offset, starting at offset 1.

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

	By default, arrays created by ingres_fetch_row(3) start from position 1 and not 0 as with other DBMS extensions. The starting position can
       be adjusted to 0 using the configuration parameter ingres.array_index_start.

       Note

	      Related Configurations

	       See also the ingres.array_index_start, ingres.fetch_buffer_size and ingres.utf8 directives in Runtime Configuration.

PARAMETERS

	      o $result
		- The query result identifier

RETURN VALUES

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

EXAMPLES

       Example #1

	      Fetch a row of result into an enumerated array

	      <?php
	      $link = ingres_connect($database, $user, $password);

	      $result = ingres_query($link, "select * from table");
	      while ($row = ingres_fetch_row($result)) {
		  echo $row[1];
		  echo $row[2];
	      }
	      ?>

SEE ALSO

       ingres_num_fields(3), ingres_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3).

PHP Documentation Group 												       INGRES_FETCH_ROW(3)

INGRES_RESULT_SEEK(3)							 1						     INGRES_RESULT_SEEK(3)

ingres_result_seek - Set the row position before fetching data

SYNOPSIS

       bool ingres_result_seek (resource  $result, int	$position)

DESCRIPTION

	This  function	is  used to position the cursor associated with the result resource before issuing a fetch. If ingres.array_index_start is
       set to 0 then the first row is 0 else it is 1. ingres_result_seek(3) can be used only with queries that make use of scrollable cursors.	It
       cannot be used with ingres_unbuffered_query(3).

       Note

	      Related Configurations

	       See also the ingres.scrollable and ingres.array_index_start directives in Runtime Configuration.

PARAMETERS

	      o $result
		- The result identifier for a query

	      o $position
		- The row to position the cursor on. If ingres.array_index_start is set to 0, then the first row is 0, else it is 1

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Position the cursor on the 3rd row

	      <?php

	      $result=ingres_query($link, "select * from airport where ap_ccode = 'ES' order by ap_place asc");

	      /* goto row 3 */
	      if (!ingres_result_seek($result, 3))
	      {
		  echo ingres_errno() . " - " . ingres_error . "
";
		  die("i died");
	      }
	      else
	      {
		  $airport = ingres_fetch_object ($result);
		  {
		      echo $airport->ap_iatacode . " - " .  $airport->ap_name . "
";
		  }
	      }

	      ingres_commit($link);

	      ?>

SEE ALSO

       ingres_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3), ingres_fetch_row(3).

PHP Documentation Group 												     INGRES_RESULT_SEEK(3)