function db_select

7.x db_select($table, $alias = NULL, array $options = array())

Returns a new SelectQuery object for the active database.


$table: The base table for this query. May be a string or another SelectQuery object. If a query object is passed, it will be used as a subselect.

$alias: The alias for the base table of this query.

$options: An array of options to control how the query operates.

Return value

SelectQuery A new SelectQuery object for this connection.

Related topics

240 calls to db_select()
actions_do in drupal/includes/
Performs a given list of actions by executing their callback functions.
AggregatorUpdatePathTestCase::testAggregatorUpdate in drupal/modules/simpletest/tests/upgrade/update.aggregator.test
Tests that the aggregator.module update is successful.
aggregator_feed_items_load in drupal/modules/aggregator/
Loads and optionally filters feed items.
blog_block_view in drupal/modules/blog/blog.module
Implements hook_block_view().
blog_feed_last in drupal/modules/blog/
Menu callback; displays an RSS feed containing recent blog entries of all users.

... See full list


drupal/includes/database/, line 2516
Core systems for the database layer.


function db_select($table, $alias = NULL, array $options = array()) {
  if (empty($options['target'])) {
    $options['target'] = 'default';
  return Database::getConnection($options['target'])->select($table, $alias, $options);