db-query-examples

<?php

if (!function_exists('krumo')) {
  has_krumo();
}



$nids = db_query('SELECT nid FROM {node} n')->fetchCol();
$query = db_select('node', 'n');
$query->addTag('ranmgkmg');
$query->fields('n', array('nid'));
$query->condition('nid', array(1,2,3,4,5), 'IN');
$results = $query->execute()->fetchCol();
$query_string = (string) $query;
$better_query_string = strtr((string) $query, $query->arguments());

krumo(array(
  $nids,
  $results,
  $query_string,
  $better_query_string
));