db_query() and db_placeholders() example #1
By adam on Sat, 01/15/2011 - 12:26
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');
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);
where $node_types is an array of node types.
Add new comment