mSQL 函数
在线手册：中文 英文
PHP手册

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

resource 型的结果集。此结果集来自对 msql_query() 的调用。

返回值

Returns the number of rows in the result set.

参见

mSQL 函数
在线手册：中文 英文
PHP手册
PHP手册 - N: Get number of rows in result

用户评论:

dd at hibm dot org (21-Apr-2009 10:23)

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;
?>

julienmurray at gmail dot com (16-May-2008 05:49)

<?php
class SQLServerAccess
{
    var $db_connection;
  

    function __construct()
    {
        $instancia = 'instance_name';
        $usuario = 'user';
        $senha = 'password';
        $banco_dados = 'data_base';
        $this->db_connection    = mssql_connect($instancia, $usuario,$senha)
                    or die('Erro de Conex?o no servidor '.$banco_dados);
                  
        mssql_select_db($banco_dados)
                    or die('O banco de dados '.$banco_dados.' n?o pode ser selecionado');
    }
  
  
}
?>
<?php
class SQLServerRange
{

        var $recordcount = 0;

        function __construct($Query,$Conn)
        {
            $query_result = mssql_query($Query, $Conn) or die('Falha na consulta : '. $Query);           
            if ($query_result)
            {
                $this->recordcount = mssql_num_rows($query_result);
            }
            return  $query_result;
        }
}
?>