sybase_fetch_array

Fetch row as array (PHP 4, PHP 5)
array sybase_fetch_array ( resource result )

Example 2524. Identical fieldnames

copy to clipboard

<?php


$dbh = sybase_connect('SYBASE', '', '');
$q = sybase_query('SELECT * FROM p, a WHERE p.person_id= a.person_id');
var_dump(sybase_fetch_array($q));
sybase_close($dbh);
?>

The above example would produce the following output (assuming the two tables only have each one column called "person_id"):

copy to clipboard

array(4) {

  [0]=>

  int(1)

  ["person_id"]=>

  int(1)

  [1]=>

  int(1)

  ["person_id1"]=>

  int(1)

}

Code Examples / Notes » sybase_fetch_array

burak3

For varchar type fields, sybase api fetch is limited with 255 characters. In sybase you can have a varchar field nearly upto a page size, ex: varchar(1500)

joey

$q = sybase_query("SELECT COUNT (DISTINCT OPPORTUNITY_ID) FROM M_OPP_INTERESTS WHERE INTEREST_ID = $i_id", $db); while ($op_by_int = sybase_fetch_array($q)) { while (list( $k, $v ) = each( $op_by_int )) { echo "\$op[$k] => $v\n"; } Returns: $op[0] => 2164 $op[computed] => 2164

Change Language

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

sybase_fetch_array

Fetch row as array (PHP 4, PHP 5) array sybase_fetch_array ( resource result )

Example 2524. Identical fieldnames

Code Examples / Notes » sybase_fetch_array

Change Language

Fetch row as array (PHP 4, PHP 5)
array sybase_fetch_array ( resource result )