public function DatabaseStatementInterface::fetchField

You are here

7 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 2036
Core systems for the database layer.

Class

DatabaseStatementInterface
Represents a prepared statement.

Code

public function fetchField($index = 0);

Comments

<?php
 
$sql
= "SELECT COUNT(*) FROM {node} WHERE type = 'page'";
 
$result = db_query($sql);
 
$pages = $result->fetchField();
 
 
$html = "There are " . $pages . " pages.";
?>

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

Fatal error: Call to a member function fields() on a non-object in D:\wamp\www\testpanta\includes\database\database.inc on line 3129