fbsql_fetch_array

Description

Returns an array that corresponds to the fetched row, or FALSE if there are no more rows_

fbsql_fetch_array() is an extended version of fbsql_fetch_row()_ In addition to storing the data in the numeric indices of the result array, it also stores the data in associative indices, using the field names as keys_

If two or more columns of the result have the same field names, the last column will take precedence_ To access the other column(s) of the same name, you must the numeric index of the column or make an alias for the column_

select t1_f1 as foo t2_f1 as bar from t1, t2

An important thing to note is that using fbsql_fetch_array() is NOT significantly slower than using fbsql_fetch_row(), while it provides a significant added value_

The optional second argument result_type in fbsql_fetch_array() is a constant and can take the following values: FBSQL_ASSOC, FBSQL_NUM, and FBSQL_BOTH_

For further details, see also fbsql_fetch_row() and fbsql_fetch_assoc()_

<?php 
fbsql_connect ($host, $user, $password);
$result = fbsql_db_query ("database","select user_id, fullname from table");
while ($row = fbsql_fetch_array ($result)) {
    echo "user_id: "_$row["user_id"]_"<br>\n";
    echo "user_id: "_$row[0]_"<br>\n";
    echo "fullname: "_$row["fullname"]_"<br>\n";
    echo "fullname: "_$row[1]_"<br>\n";
}
fbsql_free_result ($result);
?>