[support] What's wrong with this query?
    Ms. Nancy Wichmann 
    nan_wich at bellsouth.net
       
    Fri Jul  6 20:43:55 UTC 2012
    
    
  
  $result = db_select('taxonomy_term_data', 't');
  $result->addField('t', 'tid');
  $result->condition('t.vid', $vids, 'IN')
    ->condition(db_or()->condition('t.description', "%$keys%", 'LIKE')->condition('t.name', "%$keys%", 'LIKE'))
    ;
  $result->execute();
  $found = NULL;
  foreach ($result as $row) {
    $output .= print_r($row, true);
  }
The Devel query log shows the query properly built. I copied the query from the log into PhpMyAdmin and it gets one row. But my code shows nothing fetched.
 
Nancy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20120706/b6121c5a/attachment.html 
    
    
More information about the support
mailing list