This function is stores the data fetched from a query executed using ingres_query() in an associative array, using the field names as keys.
With regard to speed, the function is identical to ingres_fetch_object(), and almost as quick as ingres_fetch_row() (the difference is insignificant).
By default, arrays created by ingres_fetch_assoc() start from position 1 and not 0 as with other DBMS extensions. The starting position can be adjusted to 0 using the configuration parameter ingres.array_index_start.
Note: Related Configurations
See also the ingres.array_index_start, ingres.fetch_buffer_size and ingres.utf8 directives in Runtime Configuration.
The query result identifier
Returns an associative array that corresponds to the fetched row, or FALSE
if there are no more rows
<?php $link = ingres_connect($database, $user, $password); $result = ingres_query($link,"select * from table"); while ($row = ingres_fetch_assoc($result)) { echo $row["user_id"]; // using associative array echo $row["fullname"]; } ?>
Please login to continue.