Listing 1762

$connection = Propel::getConnection();
      
      $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);
        $c->setLimit(1);
        $params = array();
        
        $query = BasePeer::createSelectSql($c, $params);
        
    $statement = $connection->prepareStatement(str_replace('?', "'$n'", $query));
    $resultset = $statement->executeQuery();
    $resultset->next();
        print_r($resultset);