db_query() – AgileAdam.com

Have you ever wondered how to properly build a query like this in Drupal:

SELECT nid, type, title FROM node n WHERE n.type IN('page','story');

1	SELECT nid, type, title FROM node n WHERE n.type IN('page','story');

This requires the use of db_placeholders() to create the placeholder ‘ ‘, ‘ ‘, etc.

$result = db_query('SELECT nid, type, title FROM {node} n WHERE n.type IN(' . db_placeholders($node_types, 'text') . ')', $node_types);

1	$result = db_query('SELECT nid, type, title FROM {node} n WHERE n.type IN(' . db_placeholders($node_types, 'text') . ')', $node_types);

where $node_types is an array of node types.