public function DatabaseStatementInterface::fetchAllKeyed

You are here

7 database.inc public DatabaseStatementInterface::fetchAllKeyed($key_index = 0, $value_index = 1)

Returns the entire result set as a single associative array.

This method is only useful for two-column result sets. It will return an associative array where the key is one column from the result set and the value is another field. In most cases, the default of the first two columns is appropriate.

Note that this method will run the result set to the end.

Parameters

$key_index: The numeric index of the field to use as the array key.

$value_index: The numeric index of the field to use as the array value.

Return value

An associative array, or an empty array if there is no result set.

3 methods override DatabaseStatementInterface::fetchAllKeyed()
DatabaseStatementBase::fetchAllKeyed in includes/database/database.inc
Returns the entire result set as a single associative array.
DatabaseStatementEmpty::fetchAllKeyed in includes/database/database.inc
Returns the entire result set as a single associative array.
DatabaseStatementPrefetch::fetchAllKeyed in includes/database/prefetch.inc
Returns the entire result set as a single associative array.

File

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

Class

DatabaseStatementInterface
Represents a prepared statement.

Code

public function fetchAllKeyed($key_index = 0, $value_index = 1);

Comments

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