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.