function SelectQueryInterface::fields

Add multiple fields from the same table to be SELECTed.

This method does not return the aliases set for the passed fields. In the majority of cases that is not a problem, as the alias will be the field name. However, if you do need to know the alias you can call getFields() and examine the result to determine what alias was created. Alternatively, simply use addField() for the few fields you care about and this method for the rest.

Parameters

$table_alias: The name of the table from which the field comes, as an alias. Generally you will want to use the return value of join() here to ensure that it is valid.

$fields: An indexed array of fields present in the specified table that should be included in this query. If not specified, $table_alias.* will be generated without any aliases.

Return value

SelectQueryInterface The called object.

2 methods override SelectQueryInterface::fields()
SelectQuery::fields in includes/database/select.inc
Add multiple fields from the same table to be SELECTed.
SelectQueryExtender::fields in includes/database/select.inc
Add multiple fields from the same table to be SELECTed.

File

includes/database/select.inc, line 216

Class

SelectQueryInterface
Interface definition for a Select Query object.

Code

public function fields($table_alias, array $fields = array());

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.