Drupal database query example

drupal_db.php

<?php
  $values = array(1, 2, 3, 4, 5);

  $placeholders = db_placeholders($values);

  $result = db_query("SELECT t.s FROM {table} t WHERE t.field IN ($placeholders)", $values); 

  $items = array();
  while ($row = db_fetch_object($result)) {
    $items[] = $row->s;
  }