db_fetch_array

5 database.mysql.inc	`db_fetch_array($result)`
5 database.pgsql.inc	`db_fetch_array($result)`
5 database.mysqli.inc	`db_fetch_array($result)`
6 database.mysql.inc	`db_fetch_array($result)`
6 database.pgsql.inc	`db_fetch_array($result)`
6 database.mysqli.inc	`db_fetch_array($result)`

Fetch one result row from the previous query as an array.

Parameters

$result: A database query result resource, as returned from db_query().

Return value

An associative array representing the next row of the result, or FALSE. The keys of this object are the names of the table fields selected by the query, and the values are the field values for this result row.

▸ 56 functions call db_fetch_array()

▾ 56 functions call db_fetch_array()

aggregator_category_load in modules/aggregator/aggregator.module: Load an aggregator category.
aggregator_cron in modules/aggregator/aggregator.module: Implementation of hook_cron().
aggregator_feed_load in modules/aggregator/aggregator.module: Load an aggregator feed.
block_admin_configure in modules/block/block.admin.inc: Menu callback; displays the block configuration form.
block_box_get in modules/block/block.module: Returns information from database about a user-created (custom) block.
book_get_books in modules/book/book.module: Returns an array of all books.
book_link_load in modules/book/book.module: Like menu_link_load(), but adds additional data from the {book} table.
book_nodeapi in modules/book/book.module: Implementation of hook_nodeapi().
book_update_6000 in modules/book/book.install: Drupal 5.x to 6.x update.
book_update_bid in modules/book/book.module: Update the bid for a page and its children when it is moved to a new book.
color_update_6001 in modules/color/color.install: Warn site administrator if unsafe CSS color codes are found in the database.
comment_nodeapi in modules/comment/comment.module: Implementation of hook_nodeapi().
contact_load in modules/contact/contact.module: Load the data for a single contact category.
drupal_uninstall_module in includes/install.inc: Calls the uninstall function and updates the system table for a given module.
forum_nodeapi in modules/forum/forum.module: Implementation of hook_nodeapi().
forum_term_load in modules/forum/forum.module: Fetch a forum term.
hook_cron in developer/hooks/core.php: Perform periodic actions.
lock_may_be_available in includes/lock.inc: Check if lock acquired by a different process may be available.
menu_delete_menu_confirm_submit in modules/menu/menu.admin.inc: Delete a custom menu and all items in it.
menu_edit_menu_submit in modules/menu/menu.admin.inc: Submit function for adding or editing a custom menu.
menu_enable in modules/menu/menu.module: Implementation of hook_enable()
menu_get_item in includes/menu.inc: Get a router item.
menu_get_menus in modules/menu/menu.module: Return an associative array of the custom menus names.
menu_get_names in includes/menu.inc: Build a list of named menus.
menu_link_delete in includes/menu.inc: Delete one or several menu links.
menu_link_load in includes/menu.inc: Get a menu link by its mlid, access checked and link translated for rendering.
menu_link_maintain in includes/menu.inc: Insert, update or delete an uncustomized menu link related to a module.
menu_link_save in includes/menu.inc: Save a menu link.
menu_load in modules/menu/menu.module: Load the data for a single custom menu.
menu_local_tasks in includes/menu.inc: Collects the local tasks (tabs) for a given level.
menu_nodeapi in modules/menu/menu.module: Implementation of hook_nodeapi().
menu_overview_page in modules/menu/menu.admin.inc: Menu callback which shows an overview page of all the custom menus and their descriptions.
menu_tree_check_access in includes/menu.inc: Check access and perform other dynamic operations for each link in the tree.
menu_tree_page_data in includes/menu.inc: Get the data structure representing a named menu tree, based on the current page.
menu_valid_path in includes/menu.inc: Validates the path of a menu link being created or edited.
path_load in modules/path/path.module: Fetch a specific URL alias from the database.
path_set_alias in modules/path/path.module: Set an aliased path for a given Drupal path, preventing duplicates.
poll_load in modules/poll/poll.module: Implementation of hook_load().
profile_field_form in modules/profile/profile.admin.inc: Menu callback: Generate a form to add/edit a user profile field.
statistics_get in modules/statistics/statistics.module: Retrieves a node's "view statistics".
system_admin_menu_block in modules/system/system.module: Provide a single block on the administration overview page.
system_get_module_admin_tasks in modules/system/system.module: Generate a list of tasks offered by a specified module.
system_initialize_theme_blocks in modules/system/system.module: Assign an initial, default set of blocks for a theme.
system_main_admin_page in modules/system/system.admin.inc: Menu callback; Provide the administration overview page.
system_update_6021 in modules/system/system.install: Migrate the menu items from the old menu system to the new menu_links table.
taxonomy_get_synonyms in modules/taxonomy/taxonomy.module: Return an array of synonyms of the given term ID.
user_admin_access_edit in modules/user/user.admin.inc: Menu callback: edit an access rule.
user_external_load in modules/user/user.module
user_fields in modules/user/user.module
_block_rehash in modules/block/block.module: Update the 'blocks' DB table with the blocks currently exported by modules.
_book_update_outline in modules/book/book.module: Common helper function to handles additions and updates to the book outline.
_menu_delete_item in includes/menu.inc: Helper function for menu_link_delete; deletes a single menu link.
_menu_navigation_links_rebuild in includes/menu.inc: Helper function to build menu links for the items in the menu router.
_menu_set_expanded_menus in includes/menu.inc: Helper function to update a list of menus with expanded items
_menu_tree_data in includes/menu.inc: Recursive helper function to build the data representing a menu tree.
_node_access_rebuild_batch_operation in modules/node/node.module: Batch operation for node_access_rebuild_batch.

File

includes/database.pgsql.inc, line 189: Database interface code for PostgreSQL database servers.

Code

<?php
function db_fetch_array($result) {
  if ($result) {
    return pg_fetch_assoc($result);
  }
}
?>

Comments

This function can also return NULL

Posted by johnennew on March 24, 2011 at 10:57am

The PHP default function return is null. If you pass something in which causes the if statement to skip then it will return NULL and not FALSE.

Did this recently and ended up with an endless loop ....

$result = db_query(''SQL with a typo");

while (($next_record = db_fetch_array($result) !== FALSE) {
some code
}

For Drupal 7..

Posted by tmsimont on March 31, 2011 at 6:59pm

good comments here:
http://api.drupal.org/api/drupal/includes--database--database.inc/functi...