Using the Boombatower conversion tool, my query comes out to: $users = db_select('user_badges_user', 'ubu') ->fields('u', array('uid', 'name')) ->condition('ubu.bid', $badge->bid) ->join('users', 'u', 'u.uid = ubu.uid') ->execute();
But when I run this, I get: Fatal error: Call to a member function execute() on a non-object
Joins are getting to be a major pain in the derriere.
Trying this also fails with the same message: $users = db_select('user_badges_user', 'ubu') ->fields('u', array('uid', 'name')) ->condition('ubu.bid', $badge->bid) ->join('users', 'u', 'u.uid = ubu.uid'); $users->execute();
------------------------------------------------------------------------------------------------------------
And does anyone know why I so rarely get answers to my questions on this list?
Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.