PHP: fbsql_num_rows - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

fbsql_password fbsql_num_fields

Last updated: Sat, 27 Jan 2007

view this page in

# fbsql_num_rows

(PHP 4 >= 4.0.6, PHP 5)

fbsql_num_rows -- Get number of rows in result

## Описание

int fbsql_num_rows ( resource result )

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().

## Список параметров

`result`

  A result identifier returned by fbsql_query() or fbsql_db_query().

## Возвращаемые значения

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

## Примеры

Пример 1. fbsql_num_rows() 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\n";
?>`

## Смотрите также

fbsql_affected_rows()
fbsql_connect()
fbsql_select_db()
fbsql_query()

add a note User Contributed Notes
fbsql_num_rows
daggillies at yahoo dot com
05-Apr-2002 12:29
`Note that this function will not always return the actual size of a result set. For example, if you are doing a two-table join along the lines of "SELECT * FROM T1,T2 where T1.x=T2.x" you will get a result of -1. This is due to the 'lazy execution' model in FrontBase whereby result rows are only returned as you request them. If you absolutely have to have the number of rows in advance then you will have to use COUNT(*) first. Most of the time you do not need to know the exact number of rows; it is good enough to know if the size of the result set is non-zero.
David Gillies
San Jose
Costa Rica`
add a note
fbsql_password fbsql_num_fields

Last updated: Sat, 27 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 09:32:46 2007 PST