4.6.x database.pgsql.inc db_fetch_object($result)
4.6.x database.mysql.inc db_fetch_object($result)
4.7.x database.pgsql.inc db_fetch_object($result)
4.7.x database.mysqli.inc db_fetch_object($result)
4.7.x database.mysql.inc db_fetch_object($result)
5.x database.pgsql.inc db_fetch_object($result)
5.x database.mysqli.inc db_fetch_object($result)
5.x database.mysql.inc db_fetch_object($result)
6.x database.pgsql.inc db_fetch_object($result)
6.x database.mysqli.inc db_fetch_object($result)
6.x database.mysql.inc db_fetch_object($result)

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


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

Return value

An object representing the next row of the result, or FALSE. The attributes of this object are the table fields selected by the query.

Related topics

40 calls to db_fetch_object()
actions_load in includes/actions.inc
Retrieve a single action from the database.
aggregator_form_category_validate in modules/aggregator/aggregator.admin.inc
Validate aggregator_form_feed form submissions.
aggregator_page_rss in modules/aggregator/aggregator.pages.inc
Menu callback; generate an RSS 0.92 feed of aggregator items or categories.
aggregator_parse_feed in modules/aggregator/aggregator.module
Parse a feed and store its items.
cache_get in includes/cache.inc
Return data from the persistent cache. Data may be stored as either plain text or as serialized data. cache_get will automatically return unserialized objects and arrays.

... See full list


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


function db_fetch_object($result) {
  if ($result) {
    return pg_fetch_object($result);


joshua.stout’s picture

see also db_fetch_array()

alberto56’s picture

In Drupal 7, this is no longer used. See http://drupal.org/update/modules/6/7#dbtng

kenorb’s picture

Example in Drupal 7:

db_query('SELECT n.moderate FROM {node} n WHERE n.nid = :nid', array(':nid' => $node->nid))->fetch();

See: http://drupal.org/update/modules/6/7#dbtng