msql_num_rows
(PHP 4, PHP 5)
msql_num_rows — Get number of rows in result
Описание
int msql_num_rows
( resource $query_identifier
)
msql_num_rows() returns the number of rows in a result set.
Список параметров
- result
-
The result resource that is being evaluated. This result comes from a call to msql_query().
Возвращаемые значения
Returns the number of rows in the result set.
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Расширения для работы с базами данных отдельных производителей
- mSQL
- msql_affected_rows
- msql_close
- msql_connect
- msql_create_db
- msql_createdb
- msql_data_seek
- msql_db_query
- msql_dbname
- msql_drop_db
- msql_error
- msql_fetch_array
- msql_fetch_field
- msql_fetch_object
- msql_fetch_row
- msql_field_flags
- msql_field_len
- msql_field_name
- msql_field_seek
- msql_field_table
- msql_field_type
- msql_fieldflags
- msql_fieldlen
- msql_fieldname
- msql_fieldtable
- msql_fieldtype
- msql_free_result
- msql_list_dbs
- msql_list_fields
- msql_list_tables
- msql_num_fields
- msql_num_rows
- msql_numfields
- msql_numrows
- msql_pconnect
- msql_query
- msql_regcase
- msql_result
- msql_select_db
- msql_tablename
- msql
Коментарии
If you would like to just find out how many rows are returned by a query without actually using the results, then it's much more efficient to use SQL count function (specially for large tables with millions of rows).
<?php
$sql = "SELECT COUNT(indexed-field) AS cnt FROM some-table";
$r = mysql_query($sql);
$row = mysql_fetch_object($r);
echo $row->cnt;
?>