Bookmark this on Delicious Share on Facebook

PHP : Function Reference : Sybase Functions : sybase_unbuffered_query

sybase_unbuffered_query

Send a Sybase query and do not block (PHP 4 >= 4.3.0, PHP 5)
resource sybase_unbuffered_query ( string query, resource link_identifier [, bool store_result] )

Example 2529. sybase_unbuffered_query() example

copy to clipboard

<?php


$dbh = sybase_connect('SYBASE', '', '');
$q = sybase_unbuffered_query('select firstname, lastname from huge_table', $dbh, false);
sybase_data_seek($q, 10000);
$i = 0;


while ($row = sybase_fetch_row($q)) {

    echo $row[0], ' ', $row[1], '<br />';

    if ($i++ > 40000) {

        break;

    }

}

sybase_free_result($q);
sybase_close($dbh);

?>

Change Language

Follow Navioo On Twitter

sybase_affected_rows
sybase_close
sybase_connect
sybase_data_seek
sybase_deadlock_retry_count
sybase_fetch_array
sybase_fetch_assoc
sybase_fetch_field
sybase_fetch_object
sybase_fetch_row
sybase_field_seek
sybase_free_result
sybase_get_last_message
sybase_min_client_severity
sybase_min_error_severity
sybase_min_message_severity
sybase_min_server_severity
sybase_num_fields
sybase_num_rows
sybase_pconnect
sybase_query
sybase_result
sybase_select_db
sybase_set_message_handler
sybase_unbuffered_query

hits counter