fbsql_num_rows(3) [php man page]

FBSQL_NUM_ROWS(3)							 1							 FBSQL_NUM_ROWS(3)

fbsql_num_rows - Get number of rows in result

SYNOPSIS

       int fbsql_num_rows (resource  $result)

DESCRIPTION

	Gets the number of rows in the given $result set.

	This  function	is  only  valid  for SELECT statements. To retrieve the number of rows returned from a INSERT, UPDATE or DELETE query, use
       fbsql_affected_rows(3).

PARAMETERS

	      o $
		result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).

RETURN VALUES

	Returns the number of rows returned by the last SELECT statement.

EXAMPLES

       Example #1

	      fbsql_num_rows(3) example

	      <?php

	      $link = fbsql_connect("localhost", "username", "password");
	      fbsql_select_db("database", $link);

	      $result = fbsql_query("SELECT * FROM table1;", $link);
	      $num_rows = fbsql_num_rows($result);

	      echo "$num_rows Rows
";

	      ?>

SEE ALSO

       fbsql_affected_rows(3), fbsql_connect(3), fbsql_select_db(3), fbsql_query(3).

PHP Documentation Group 													 FBSQL_NUM_ROWS(3)

FBSQL_AFFECTED_ROWS(3)							 1						    FBSQL_AFFECTED_ROWS(3)

fbsql_affected_rows - Get number of affected rows in previous FrontBase operation

SYNOPSIS

       int fbsql_affected_rows ([resource  $link_identifier])

DESCRIPTION

       fbsql_affected_rows(3) returns the number of rows affected by the last INSERT, UPDATE or DELETE query associated with $link_identifier.

       Note

	       If  you	are  using transactions, you need to call fbsql_affected_rows(3) after your INSERT, UPDATE, or DELETE query, not after the
	      commit.

	If the last query was a DELETE query with no WHERE clause, all of the records will have been deleted from the table but this function will
       return zero.

       Note

	       When using UPDATE, FrontBase will not update columns where the new value is the same as the old value. This creates the possibility
	      that fbsql_affected_rows(3) may not actually equal the number of rows matched, only the number of rows that were literally  affected
	      by the query.

PARAMETERS

	      o $
		link_identifier  -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
		function will try to find an open link to the FrontBase server and if no such link is found it	will  try  to  create  one  as	if
		fbsql_connect(3) was called with no arguments.

RETURN VALUES

	If the last query failed, this function will return -1.

SEE ALSO

       fbsql_num_rows(3).

PHP Documentation Group 												    FBSQL_AFFECTED_ROWS(3)