php man page for maxdb_use_result

MAXDB_USE_RESULT(3)							 1						       MAXDB_USE_RESULT(3)

maxdb_use_result - Initiate a result set retrieval

       Procedural style

SYNOPSIS
       resource maxdb_use_result (resource  $link)

DESCRIPTION
       Object oriented style
       resource maxdb::use_result (void  )

       maxdb_use_result(3) has no effect.

RETURN VALUES
	Returns result or FALSE on failure.

EXAMPLES
       Example #1

	      Object oriented style

	      <?php
	      $maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");

	      /* check connection */
	      if (maxdb_connect_errno()) {
		 printf("Connect failed: %s
", maxdb_connect_error());
		 exit();
	      }

	      $query  = "SELECT * FROM DUAL";

	      /* execute multi query */
	      if ($maxdb->multi_query($query)) {
		 do {
		     /* store first result set */
		     if ($result = $maxdb->use_result()) {
			 while ($row = $result->fetch_row()) {
			     printf("%s
", $row[0]);
			 }
			 $result->close();
		     }
		     /* print divider */
		     if ($maxdb->more_results()) {
			 printf("-----------------
");
		     }
		 } while ($maxdb->next_result());
	      }

	      /* close connection */
	      $maxdb->close();
	      ?>

       Example #2

	      Procedural style

	      <?php
	      $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

	      /* check connection */
	      if (maxdb_connect_errno()) {
		 printf("Connect failed: %s
", maxdb_connect_error());
		 exit();
	      }

	      $query  = "SELECT * FROM DUAL";

	      /* execute multi query */
	      if (maxdb_multi_query($link, $query)) {
		 do {
		     /* store first result set */
		     if ($result = maxdb_use_result($link)) {
			 while ($row = maxdb_fetch_row($result)) {
			     printf("%s
", $row[0]);
			 }
			 maxdb_free_result($result);
		     }
		     /* print divider */
		     if (maxdb_more_results($link)) {
			 printf("-----------------
");
		     }
		 } while (maxdb_next_result($link));
	      }

	      /* close connection */
	      maxdb_close($link);
	      ?>

       The above example will output something similar to:

       a

SEE ALSO
       maxdb_real_query(3), maxdb_store_result(3).

PHP Documentation Group 												       MAXDB_USE_RESULT(3)