Query in database with join in drupal

Question

This code not working

$var = db_select('taxonomy_term_data', 'tt')
  ->fields('tt', array('name'))
  ->join('my_table', 'dd', 'tt.tid = dd.my_field')
  ->execute()

But next code working normally.

$var = db_query('SELECT name FROM taxonomy_term_data tt JOIN my_table dd ON tt.tid = dd.my_field')

where went my wrong?

Make sure you use the top db_select syntax instead of direct query statement to avoid SQL Injection attacks.. It temping given how complicated the db_select syntax can be when joining tables. — Kye
– Kye, Commented Aug 20, 2013 at 6:50

Clive · Accepted Answer · 2013-08-19 11:53:09Z

2

join() isn't chain-able, use

$query = db_select('taxonomy_term_data', 'tt')->fields('tt', array('name'));
$query->join('my_table', 'dd', 'tt.tid = dd.my_field');
$var = $query->execute()

answered Aug 19, 2013 at 11:53

Clive

36.9k8 gold badges89 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query in database with join in drupal

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related