msql_num_fields
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;
?>
msql_num_rows
(PHP 4, PHP 5)
msql_num_rows — Get number of rows in result
Description
int msql_num_rows
( resource
$query_identifier
)msql_num_rows() returns the number of rows in a result set.
Parameters
-
result -
The result resource that is being evaluated. This result comes from a call to msql_query().
Return Values
Returns the number of rows in the result set.
add a note
User Contributed Notes
msql_num_rows - [2 notes]
dd at hibm dot org ¶
4 years ago
julienmurray at gmail dot com ¶
4 years ago
<?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;
}
}
?>