Bookmark this on Delicious Share on Facebook

PHP : Function Reference : Microsoft SQL Server Functions : mssql_fetch_batch

mssql_fetch_batch

Returns the next batch of records (PHP 4 >= 4.0.4, PHP 5, PECL odbtp:1.1.1-1.1.4)
int mssql_fetch_batch ( resource result )

Example 1376. mssql_fetch_batch() Example

copy to clipboard

<?php

$resDb = mssql_connect('localhost', 'user', 'name');
$result = mssql_query('SELECT * FROM MYTABLE', $resDb, 10000);

$intNumRows = mssql_num_rows($result);


while ($intNumRows > 0) {

    while ($arrRow = mssql_fetch_assoc($result)) {

        // Do stuff ...

    }

    $intNumRows = mssql_fetch_batch($result);

}
?>

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

hits counter