7.x database.inc public DatabaseStatementInterface::fetchField($index = 0)

Returns a single field from the next record of a result set.

Parameters

$index: The numeric index of the field to return. Defaults to the first field.

Return value

A single field from the next record, or FALSE if there is no next record.

3 methods override DatabaseStatementInterface::fetchField()
DatabaseStatementBase::fetchField in includes/database/database.inc
Returns a single field from the next record of a result set.
DatabaseStatementEmpty::fetchField in includes/database/database.inc
Returns a single field from the next record of a result set.
DatabaseStatementPrefetch::fetchField in includes/database/prefetch.inc
Returns a single field from the next record of a result set.

File

includes/database/database.inc, line 2069
Core systems for the database layer.

Class

DatabaseStatementInterface
Represents a prepared statement.

Code

public function fetchField($index = 0);

Comments

drupalshrek’s picture

$sql = "SELECT COUNT(*) FROM {node} WHERE type = 'page'";
  $result = db_query($sql);
  $pages = $result->fetchField();
  
  $html = "There are " . $pages . " pages.";
Elijah Lynn’s picture

See the other DatabaseStatementInterface methods here:
http://api.drupal.org/api/drupal/includes!database!database.inc/interfac...