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



PHP : Function Reference : Sybase Functions : sybase_fetch_row

sybase_fetch_row

Get a result row as an enumerated array (PHP 4, PHP 5)
array sybase_fetch_row ( resource result )

sybase_fetch_row() fetches one row of data from the result associated with the specified result identifier.

Subsequent call to sybase_fetch_row() would return the next row in the result set, or FALSE if there are no more rows.

Parameters

result

Return Values

Returns an array that corresponds to the fetched row, or FALSE if there are no more rows. Each result column is stored in an array offset, starting at offset 0.

Table 320. Data types

PHP Sybase
string VARCHAR, TEXT, CHAR, IMAGE, BINARY, VARBINARY, DATETIME
int NUMERIC (w/o precision), DECIMAL (w/o precision), INT, BIT, TINYINT, SMALLINT
float NUMERIC (w/ precision), DECIMAL (w/ precision), REAL, FLOAT, MONEY
NULL NULL


Code Examples / Notes » sybase_fetch_row

mikeegg

Just a simple example modified from the sybase_fetch_array():
<title>sybase example</title>
<?php
   $db = sybase_connect("sybtest", "sa", "teacher");
   $q = sybase_query("select name from syslogins", $db);
   while($row = sybase_fetch_row($q)) {
       while(list($k, $v) = each($row)) {
           echo "\$row[$k] => $v\n";
       }
   }
?>
$row[0] => dnld
$row[0] => edi
$row[0] => oes
$row[0] => oesuseradmin
$row[0] => rpts
$row[0] => sa
$row[0] => upld


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