Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : Microsoft SQL Server Functions : mssql_num_rows

mssql_num_rows

Gets the number of rows in result (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4)
int mssql_num_rows ( resource result )

Examples ( Source code ) » mssql_num_rows

<?php
// Connect to MSSQL and select the database
mssql_connect('navioo\SQLEXPRESS''sa''phpfepsilon); 
mssql_select_db('
php');

// Select all our records from a table
$query = mssql_query('
SELECT FROM [php].[dbo].[persons]');

echo '
Total records in database: ' . mssql_num_rows($query);

// Clean up
mssql_free_result($query);
?>

Code Examples / Notes » mssql_num_rows

jose_dandrade

When connecting to MS SQL, I think it is not right to try mssql_num_rows() or mssql_free_result() on a DELETE Query. Because there is nothing to return.
$db = mssql_connect('server','user','password') or die('No Connection');
mssql_select_db('database',$db);

$rs2 = mssql_query('DELETE from table',$db);
$p = mssql_num_rows($rs2);
mssql_free_result($rs2);
You might receive a warning like:
Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource


h dot schuemann

For getting something like "mssql_affected_rows" call:
$rsRows = mssql_query("select @@rowcount as rows", $db);
$rows = mssql_result($rsRows, 0, "rows");
after execution of the query (UPDATE, INSERT or DELETE).


Change Language


Follow Navioo On Twitter
mssql_bind
mssql_close
mssql_connect
mssql_data_seek
mssql_execute
mssql_fetch_array
mssql_fetch_assoc
mssql_fetch_batch
mssql_fetch_field
mssql_fetch_object
mssql_fetch_row
mssql_field_length
mssql_field_name
mssql_field_seek
mssql_field_type
mssql_free_result
mssql_free_statement
mssql_get_last_message
mssql_guid_string
mssql_init
mssql_min_error_severity
mssql_min_message_severity
mssql_next_result
mssql_num_fields
mssql_num_rows
mssql_pconnect
mssql_query
mssql_result
mssql_rows_affected
mssql_select_db
eXTReMe Tracker