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



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

<?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
eXTReMe Tracker