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.