db_fetch_array

Versions
5 – 6
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. 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.

Related topics

▾ 129 functions call db_fetch_array()

aggregator_cron in core/modules/aggregator/aggregator.module
Implementation of hook_cron().
aggregator_get_category in core/modules/aggregator/aggregator.module
aggregator_get_feed in core/modules/aggregator/aggregator.module
aggregator_menu in core/modules/aggregator/aggregator.module
Implementation of hook_menu().
block_admin_configure in core/modules/block/block.module
Menu callback; displays the block configuration form.
block_box_get in core/modules/block/block.module
book_nodeapi in core/modules/book/book.module
Implementation of hook_nodeapi().
comment_nodeapi in core/modules/comment/comment.module
Implementation of hook_nodeapi().
contact_admin_edit in core/modules/contact/contact.module
Category edit page.
content_alter_db_field in contrib/cck/content_admin.inc
Perform adds, alters, and drops as needed to synchronize the database with new field definitions.
content_copy_record_macro in contrib/cck/content_copy.module
A handler that stores the form submissions into a $GLOBALS array
content_field in contrib/cck/content.module
Implementation of hook_field(). Handles common field housekeeping.
content_field_delete in contrib/cck/content_crud.inc
Delete an existing field.
content_types_rebuild in contrib/cck/content_crud.inc
Rebuild content type information from node tables.
content_update_10 in contrib/cck/content.install
Fix corrupted db due to a bug in 1.3 release (http://drupal.org/node/115332)
content_update_1002 in contrib/cck/content.install
Add display_settings column
content_update_1004 in contrib/cck/content.install
Fix corrupted db due to a bug in 1.3 release (http://drupal.org/node/115332)
content_update_1009 in contrib/cck/content.install
Index the 'nid' column on data tables to optimize node deletion. Large tables might deserve a multipass update.
content_update_5 in contrib/cck/content.install
Move data from per-field storage to per-content-type storage where possible.
content_views_field_handler_group in contrib/cck/content_views.inc
date_copy_import_event_form in contrib/date/date_copy/date_copy.module
Event import form.
date_data_integrity in contrib/date/date/date.install
Progressive update of date information, integrity checking of all date values.
date_event_zonelist_by_name in contrib/date/date_timezone/date_timezone.module
Helper function to update Event module timezone information.
date_timezone_names in contrib/date/date_api.module
A translated array of timezone names. Cache the untranslated array, make the translated array a static variable.
date_update_5206 in contrib/date/date/date.install
Granularity options were not saved correctly by CCK if created using checkboxes. Checkboxes have been changed back to a select and we need to fix the values stored in the settings.
date_update_5207 in contrib/date/date/date.install
Get rid of jscalendar popup widget. Originally update_5201, but that was broken.
date_update_5209 in contrib/date/date/date.install
Update all repeating date delta values with the RRULE so we can use that info in Views when we pull individual items out in a query.
date_views_field_handler_group in contrib/date/date/date_views.inc
drupal_notify in core/modules/drupal/drupal.module
Sends a ping to the Drupal directory server.
event_update_2 in contrib/event/event.install
The database tables were altered slightly in the first few months of the 4.6 branch of the module. This update checks to see which version of the event table is installed on the site, and updates the necessary columns.
fieldgroup_update_2 in contrib/cck/fieldgroup.install
add display settings for the group
fieldgroup_update_3 in contrib/cck/fieldgroup.install
converts group settings collapsible/collapsed => style
filefield_meta_filefield in contrib/filefield/filefield_meta/filefield_meta.module
fivestar_comment_load in contrib/fivestar/fivestar_comment.module
Get a current rating for a comment.
gom_get_groups in contrib/devel/generate/generate-og2list-mail.php
gou_get_groups in contrib/devel/generate/generate-og-users.php
hook_cron in hooks/core.php
Perform periodic actions.
hook_init in hooks/core.php
Perform setup tasks.
i18n_nodeapi in contrib/i18n/i18n.module
Implementation of hook_nodeapi().
imagecache_action in contrib/imagecache/imagecache.module
imagecache_presets in contrib/imagecache/imagecache.module
Get an array of all presets and their settings.
imagecache_preset_actions in contrib/imagecache/imagecache.module
imagecache_update_4 in contrib/imagecache/imagecache.install
imagefield_update_4 in contrib/imagefield/imagefield.install
Change default formatter back from 'imagefield_default' to 'default'.
location_load_location in contrib/location/location.module
Load a single location by lid.
location_search_form_alter in contrib/location/contrib/location_search/location_search.module
location_views_filter_handler_proximity in contrib/location/contrib/location_views/location_views.module
menu_edit_item_form in core/modules/menu/menu.module
Present the menu item editing form.
menu_edit_menu_form in core/modules/menu/menu.module
Menu callback; handle the adding/editing of a new menu.
menu_form_alter in core/modules/menu/menu.module
Implementation of hook_form_alter(). Add menu item fields to the node form.
nodereference_field_settings in contrib/cck/nodereference.module
Implementation of hook_field_settings().
nodewords_update_1 in contrib/nodewords/nodewords.install
Update: nodewords.module < version 1.9 to nodewords.module version >= 1.9
nodewords_update_2 in contrib/nodewords/nodewords.install
Update: nodewords.module <= version v.14 to nodewords.module version >= 1.15
og_get_subscriptions in contrib/og/og.module
og_load_group in contrib/og/og.module
og_xmlrpc_get_all_subscribers in contrib/og/og_xmlrpc.inc
optionwidgets_update_1 in contrib/cck/optionwidgets.install
Reformat allowed values settings into new key|label format
panels_book_parent_context in contrib/panels/relationships/book_parent.inc
Return a new context based on an existing context
panels_content_visibility_check_SAMPLE_CT in contrib/panels/docs/sample_plugin_ct.inc
panels_load_displays in contrib/panels/panels.module
Load and fill the requested $display object(s).
panels_node_load in contrib/panels/panels_node/panels_node.module
Implementation of hook_load().
panels_term_parent_context in contrib/panels/relationships/term_parent.inc
Return a new context based on an existing context
panels_views_legacy_content_types in contrib/panels/panels_views_legacy/panels_views_legacy.module
Return all content types available.
path_load in core/modules/path/path.module
Fetch a specific URL alias from the database.
path_redirect_load in contrib/path_redirect/path_redirect.module
Retrieve the specified URL redirect
performance_nagios in contrib/devel/performance/performance.module
Implementation of hook_nagios()
performance_view_details in contrib/devel/performance/performance.module
performance_view_summary in contrib/devel/performance/performance.module
poll_load in core/modules/poll/poll.module
Implementation of hook_load().
profile_field_form in core/modules/profile/profile.module
Menu callback: Generate a form to add/edit a user profile field.
scheduler_nodeapi in contrib/scheduler/scheduler.module
Implementation of hook_nodeapi().
statistics_get in core/modules/statistics/statistics.module
Retrieves a node's "view statistics".
system_initialize_theme_blocks in core/modules/system/system.module
Assign an initial, default set of blocks for a theme.
system_update_151 in core/modules/system/system.install
taxonomy_get_synonyms in core/modules/taxonomy/taxonomy.module
Return an array of synonyms of the given term ID.
uc_address_format in contrib/ubercart/uc_store/uc_store.module
Format an address for display based on a country's address format.
uc_attribute_priced_attributes in contrib/ubercart/uc_attribute/uc_attribute.module
Get the price affecting attributes for a product
uc_authorizenet_silent_post in contrib/ubercart/payment/uc_authorizenet/uc_authorizenet.module
uc_country_select in contrib/ubercart/uc_store/uc_store.module
Create a country select box for a form. $display can be 'name', 'code2' for the 2-digit code, or 'code3' for the 3-digit code.
uc_credit_cron in contrib/ubercart/payment/uc_credit/uc_credit.module
Implementation of hook_cron().
uc_credit_encrypt_existing in contrib/ubercart/payment/uc_credit/uc_credit.module
uc_credit_references in contrib/ubercart/payment/uc_credit/uc_credit.module
Return any transaction references on a given user's orders.
uc_cybersource_update_1 in contrib/ubercart/payment/uc_cybersource/uc_cybersource.install
uc_get_addresses in contrib/ubercart/uc_store/uc_store.module
uc_get_country_data in contrib/ubercart/uc_store/uc_store.module
Returns the rows of countries whose data matches the fields specified in the $fields array.
uc_order_status_list in contrib/ubercart/uc_order/uc_order.module
Return a sorted list of order statuses, sortable by order state/scope.
uc_product_administration in contrib/ubercart/uc_product/uc_product.module
List the subcategories of product administration.
uc_product_enable in contrib/ubercart/uc_product/uc_product.module
Implementation of hook_enable().
uc_product_features in contrib/ubercart/uc_product/uc_product.module
Displays the project features tab on a product node edit form.
uc_product_image_defaults in contrib/ubercart/uc_product/uc_product.module
Set up imagefield and imagecache for products.
uc_product_store_status in contrib/ubercart/uc_product/uc_product.module
Display the status of the product image handlers. See alsouc_product_image_defaults
uc_quote_order in contrib/ubercart/shipping/uc_quote/uc_quote.module
Implementation of hook_order().
uc_recurring_admin in contrib/ubercart/payment/uc_recurring/uc_recurring.module
uc_recurring_cron in contrib/ubercart/payment/uc_recurring/uc_recurring.module
Implementation of hook_cron().
uc_recurring_fee_load in contrib/ubercart/payment/uc_recurring/uc_recurring.module
Loads a recurring fee either from a product or for a user.
uc_recurring_user_table in contrib/ubercart/payment/uc_recurring/uc_recurring.module
uc_reports_customers in contrib/ubercart/uc_reports/uc_reports.module
Display the customer report
uc_reports_products in contrib/ubercart/uc_reports/uc_reports.module
Display the product reports
uc_reports_products_custom in contrib/ubercart/uc_reports/uc_reports.module
Display the product reports
uc_reports_sales_summary in contrib/ubercart/uc_reports/uc_reports.module
uc_stock_edit_form in contrib/ubercart/uc_stock/uc_stock.module
uc_store_customer_orders in contrib/ubercart/uc_store/uc_store.module
uc_taxes_copy in contrib/ubercart/uc_taxes/uc_taxes.module
Copy a tax rule.
uc_taxes_form in contrib/ubercart/uc_taxes/uc_taxes.module
Create or edit a tax rule. See alsouc_taxes_form_submit
uc_ups_fulfill_order in contrib/ubercart/shipping/uc_ups/uc_ups.module
Shipment creation callback.
uc_ups_nodeapi in contrib/ubercart/shipping/uc_ups/uc_ups.module
Implementation of hook_nodeapi().
uc_usps_nodeapi in contrib/ubercart/shipping/uc_usps/uc_usps.module
Implementation of hook_nodeapi().
update_convert_table_utf8 in core/update.php
Convert a single MySQL table to UTF-8.
update_fix_access_table in core/update.php
user_admin_access_edit in core/modules/user/user.module
Menu callback: edit an access rule
user_external_load in core/modules/user/user.module
user_fields in core/modules/user/user.module
views_update_12 in contrib/views/views.install
_backup_migrate_dump_table_data_sql_to_handle in contrib/backup_migrate/backup_migrate.module
Get the sql to insert the data for a given table
_backup_migrate_get_tables in contrib/backup_migrate/backup_migrate.module
Get a list of tables in the db. Works with MySQL, Postgres not tested.
_backup_migrate_get_table_names in contrib/backup_migrate/backup_migrate.module
Get the list of table names.
_backup_migrate_get_table_structure_sql in contrib/backup_migrate/backup_migrate.module
Get the sql for the structure of the given table.
_content_admin_field_add_existing_submit in contrib/cck/content_admin.inc
Add an existing field to a content type.
_content_admin_type_fields in contrib/cck/content_admin.inc
Menu callback; lists all defined fields for quick reference.
_content_type_info in contrib/cck/content.module
Collate all information on content types, fields, and related structures.
_emthumb_file_load in contrib/emfield/contrib/emthumb/emthumb.module
_filefield_file_load in contrib/filefield/filefield.module
_i18nblocks_nodeasblock in contrib/i18n/i18nblocks/i18nblocks.module
Helper function: collect translation nids and get related nodeasblock block
_imagefield_file_load in contrib/imagefield/imagefield.module
_location_search in contrib/location/contrib/location_search/location_search.module
Implementation of hook_search(). (forwarded from location.module)
_location_views_expand_map in contrib/location/contrib/location_views/location_views.module
_nodewords_detect_type_and_ids in contrib/nodewords/nodewords.module
Try to guess the $type and $ids by looking at $_GET['q'].
_system_update_utf8 in core/includes/install.inc
Converts a set of tables to UTF-8 encoding.
_views_load_view in contrib/views/views.module
Load a view from the database. (deprecated; use views_load_view in favor of this function).

Code

core/includes/database.mysql.inc, line 203

<?php
function db_fetch_array($result) {
  if ($result) {
    return mysql_fetch_array($result, MYSQL_ASSOC);
  }
}
?>