Listing 1760

          $c = new Criteria();
          $c->add(self::NICKNAME, $n);
          $c->addJoin(self::LAND, LandsPeer::ID, Criteria::LEFT_JOIN);
        $c->addJoin(self::SMOKE, SmokesPeer::ID, Criteria::LEFT_JOIN);
        $c->addJoin(self::DRINK, DrinksPeer::ID, Criteria::LEFT_JOIN);
        $c->addSelectColumn(LandsPeer::NAME);
        $c->addSelectColumn(SmokesPeer::NAME);
        $c->addSelectColumn(DrinksPeer::NAME);
        $rs = self::doSelectRS($c);
        $rs->next();
        $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC);
        print_r($rs);