title: PHRETS - Pulling out MLS agent informations
body: <pre><code>$search = $rets-&gt;SearchQuery("User",11,"(2699=1900-01-01+)");
  while ($listing = $rets-&gt;FetchRow($search)) {
      echo print_r($listing);
  }
  </code></pre>
  
  <p>Trying to pull out all MLS agents using these settings, but just cant get to see anything at all, i have tried so many options, but nothing pass on.</p>
  
  <pre><code>The Field : [2699] =&gt; LastLoginDate
  (Pulled out directly from get metadatatable)
  </code></pre>
  
  <p>I can perfectly pull out listings without any issues using the same code above with different classname and codes. The User just wont go through, anything i am missing ?  Thanks alot</p>
  
  <p>Here is my result from metadata tables (So that you see that my User and 11 are good)</p>
  
  <pre><code>  Array
     (
     [0] =&gt; Array
      (
          [Resource] =&gt; DeletedListing
          [Data] =&gt; Array
              (
                  [0] =&gt; Array
                      (
                          [ClassName] =&gt; 1021
                          [VisibleName] =&gt; DeletedListing
                          [StandardName] =&gt; 
                          [Description] =&gt; Deleted Listings
                          [TableVersion] =&gt; 28.63.49757
                          [TableDate] =&gt; Thu, 28 Jul 2011 05:35:57 GMT
                          [UpdateVersion] =&gt; 
                          [UpdateDate] =&gt; 
                      )
  
              )
  
      )
  
  [1] =&gt; Array
      (
          [Resource] =&gt; Office
          [Data] =&gt; Array
              (
                  [0] =&gt; Array
                      (
                          [ClassName] =&gt; 12
                          [VisibleName] =&gt; OFF
                          [StandardName] =&gt; Office
                          [Description] =&gt; Office
                          [TableVersion] =&gt; 37.45.13672
                          [TableDate] =&gt; Tue, 13 May 2014 15:34:32 GMT
                          [UpdateVersion] =&gt; 
                          [UpdateDate] =&gt; 
                      )
  
              )
  
      )
  
  [2] =&gt; Array
      (
          [Resource] =&gt; Property
          [Data] =&gt; Array
              (
                  [0] =&gt; Array
                      (
                          [ClassName] =&gt; 1
                          [VisibleName] =&gt; RES
                          [StandardName] =&gt; ResidentialProperty
                          [Description] =&gt; Residential
                          [TableVersion] =&gt; 37.91.89015
                          [TableDate] =&gt; Sun, 06 Jul 2014 18:16:55 GMT
                          [UpdateVersion] =&gt; 
                          [UpdateDate] =&gt; 
                      )
  
                  [1] =&gt; Array
                      (
                          [ClassName] =&gt; 2
                          [VisibleName] =&gt; CON
                          [StandardName] =&gt; 
                          [Description] =&gt; Condominium
                          [TableVersion] =&gt; 37.59.63841
                          [TableDate] =&gt; Fri, 30 May 2014 10:24:01 GMT
                          [UpdateVersion] =&gt; 
                          [UpdateDate] =&gt; 
                      )
  
                  [2] =&gt; Array
                      (
                          [ClassName] =&gt; 3
                          [VisibleName] =&gt; MUL
                          [StandardName] =&gt; MultiFamily
                          [Description] =&gt; Multifamily
                          [TableVersion] =&gt; 37.59.63864
                          [TableDate] =&gt; Fri, 30 May 2014 10:24:24 GMT
                          [UpdateVersion] =&gt; 
                          [UpdateDate] =&gt; 
                      )
  
                  [3] =&gt; Array
                      (
                          [ClassName] =&gt; 4
                          [VisibleName] =&gt; LOT
                          [StandardName] =&gt; LotsAndLand
                          [Description] =&gt; Lots
                          [TableVersion] =&gt; 37.59.63885
                          [TableDate] =&gt; Fri, 30 May 2014 10:24:45 GMT
                          [UpdateVersion] =&gt; 
                          [UpdateDate] =&gt; 
                      )
  
                  [4] =&gt; Array
                      (
                          [ClassName] =&gt; 5
                          [VisibleName] =&gt; FAR
                          [StandardName] =&gt; 
                          [Description] =&gt; Farm
                          [TableVersion] =&gt; 37.59.63903
                          [TableDate] =&gt; Fri, 30 May 2014 10:25:03 GMT
                          [UpdateVersion] =&gt; 
                          [UpdateDate] =&gt; 
                      )
  
                  [5] =&gt; Array
                      (
                          [ClassName] =&gt; 6
                          [VisibleName] =&gt; RNT
                          [StandardName] =&gt; 
                          [Description] =&gt; Rental
                          [TableVersion] =&gt; 37.59.63920
                          [TableDate] =&gt; Fri, 30 May 2014 10:25:20 GMT
                          [UpdateVersion] =&gt; 
                          [UpdateDate] =&gt; 
                      )
  
                  [6] =&gt; Array
                      (
                          [ClassName] =&gt; 10
                          [VisibleName] =&gt; ICI
                          [StandardName] =&gt; 
                          [Description] =&gt; Commercial
                          [TableVersion] =&gt; 37.59.63952
                          [TableDate] =&gt; Fri, 30 May 2014 10:25:52 GMT
                          [UpdateVersion] =&gt; 
                          [UpdateDate] =&gt; 
                      )
  
                  [7] =&gt; Array
                      (
                          [ClassName] =&gt; 13
                          [VisibleName] =&gt; XProp
                          [StandardName] =&gt; CommonInterest
                          [Description] =&gt; Cross-Property and Open House
                          [TableVersion] =&gt; 37.58.83323
                          [TableDate] =&gt; Thu, 29 May 2014 12:02:03 GMT
                          [UpdateVersion] =&gt; 
                          [UpdateDate] =&gt; 
                      )
  
              )
  
      )
  
  [3] =&gt; Array
      (
          [Resource] =&gt; User
          [Data] =&gt; Array
              (
                  [0] =&gt; Array
                      (
                          [ClassName] =&gt; 11
                          [VisibleName] =&gt; USE
                          [StandardName] =&gt; Agent
                          [Description] =&gt; Member
                          [TableVersion] =&gt; 37.50.77785
                          [TableDate] =&gt; Tue, 20 May 2014 04:16:25 GMT
                          [UpdateVersion] =&gt; 
                          [UpdateDate] =&gt; 
                      )
  
              )
  
      )
  </code></pre>
  
  <p>)</p>
  
  <p>Meta Table for the Ressource USER and class 11</p>
  
  <pre><code>Array
  (
      [sysid] =&gt; sysid
      [1662] =&gt; Address 1
      [1663] =&gt; WorkPhone
      [1664] =&gt; EMail Address
      [1665] =&gt; Agent Home Page
      [1666] =&gt; Access Flag
      [1669] =&gt; CellPhone
      [1670] =&gt; PagerPhone
      [1671] =&gt; City
      [1672] =&gt; State
      [1673] =&gt; MiddleName
      [1674] =&gt; NickName
      [1675] =&gt; Comments
      [1676] =&gt; OfficePID
      [1677] =&gt; OfficeContactNotes
      [1678] =&gt; SecurityType
      [1679] =&gt; Yellow Pages Flag (Old)
      [1680] =&gt; Office Phone (Unused)
      [1681] =&gt; Office Fax (Old)
      [1682] =&gt; BillingAddress1
      [1683] =&gt; BillingAddress2
      [1684] =&gt; BillingCity
      [1685] =&gt; BillingState
      [1686] =&gt; BillingZipCode
      [1687] =&gt; BillingPhone
      [1688] =&gt; BillingFaxPhone
      [1689] =&gt; DeliveryAddress1
      [1690] =&gt; DeliveryAddress2
      [1691] =&gt; DeliveryCity
      [1692] =&gt; DeliveryState
      [1693] =&gt; DeliveryZipCode
      [1694] =&gt; DeliveryPhone
      [1695] =&gt; DeliveryFaxPhone
      [1696] =&gt; DeliveryPID
      [1697] =&gt; DeliveryRoute
      [1698] =&gt; DeliveryStop
      [1699] =&gt; DeliveryNotes
      [1700] =&gt; DeliveryCommAdrs
      [1701] =&gt; KeyCardID
      [1702] =&gt; AffiliateType
      [1703] =&gt; OfficeVoiceExt
      [1704] =&gt; AccountingNum
      [1705] =&gt; OtherLicenseNum
      [1706] =&gt; NRDSMemberID
      [1707] =&gt; PublishingProd1
      [1708] =&gt; PublishingProd2
      [1709] =&gt; PublishingProd3
      [1710] =&gt; PublishingProd4
      [1711] =&gt; Access Flag Date (Old)
      [1712] =&gt; NetMLSAccess
      [1713] =&gt; DataLinkAccess
      [1714] =&gt; CensusGroup
      [1715] =&gt; CensusTract
      [1716] =&gt; CensusBlock
      [1717] =&gt; BSMemberPrimaryIndicator
      [1718] =&gt; Roster Flag
      [1719] =&gt; Yellow Page Flag
      [1720] =&gt; Direct Line
      [1721] =&gt; BSGender
      [1722] =&gt; BSHomeZIPCode
      [1723] =&gt; BSHomeZIPCode6
      [1724] =&gt; BSMailAddress
      [1725] =&gt; BSMailAttnCareOf
      [1726] =&gt; BSMailCity
      [1727] =&gt; BSMailState
      [1728] =&gt; BSMailZIPCode
      [1729] =&gt; BSMailZIPCode6
      [1730] =&gt; BSPreferredMail
      [1731] =&gt; BSPreferredPublication
      [1732] =&gt; BSHomeAreaCode
      [1733] =&gt; Home Phone Number (Old)
      [1734] =&gt; BSPersonalFaxArea
      [1735] =&gt; Personal Fax (Old)
      [1736] =&gt; BSPreferredFax
      [1737] =&gt; BSOfficeID
      [1738] =&gt; Member Class
      [1739] =&gt; BSJoinedDate
      [1740] =&gt; BSOrientationDate
      [1741] =&gt; BSStatus
      [1742] =&gt; BSStatusDate
      [1743] =&gt; BSPreviousNonMember
      [1744] =&gt; BSDuesWaivedLocal
      [1745] =&gt; BSDuesWaivedState
      [1746] =&gt; Board
      [1747] =&gt; BSSocialSecurityNumber
      [1748] =&gt; MLXchange # of Accesses
      [1749] =&gt; BSBirthDate
      [1750] =&gt; BSTransferDate
      [1751] =&gt; BSStopMail
      [1752] =&gt; BSJunkMailFlag
      [1753] =&gt; BSOnlineStatus
      [1754] =&gt; Access Flag Date
      [1755] =&gt; BSPrimaryAssociationID
      [1756] =&gt; BSSecondaryAssociationID1
      [1757] =&gt; BSSecondaryAssociationID2
      [1758] =&gt; BSSecondaryAssociationID3
      [1759] =&gt; BSPrimaryStateAssocID
      [1760] =&gt; BSSecondaryStateAssocID1
      [1761] =&gt; BSSecondaryStateAssocID2
      [1762] =&gt; BSSecondaryStateAssocID3
      [1763] =&gt; BSAffiliationCode#1
      [1764] =&gt; BSAffiliationCode#2
      [1765] =&gt; BSAffiliationCode#3
      [1766] =&gt; BSAffiliationCode#4
      [1767] =&gt; BSAffiliationCode#5
      [1768] =&gt; BSAffiliationCode#6
      [1769] =&gt; BSAffiliationCode#7
      [1770] =&gt; BSAffiliationCode#8
      [1771] =&gt; BSAffiliationCode#9
      [1772] =&gt; BSAffiliationCode#10
      [1773] =&gt; BSAffiliationCode#11
      [1774] =&gt; BSAffiliationCode#12
      [1775] =&gt; BSDesignationDate#1
      [1776] =&gt; BSDesignationCode#1
      [1777] =&gt; BSDesignationCode#2
      [1778] =&gt; BSDesignationDate#2
      [1779] =&gt; BSDesignationCode#3
      [1780] =&gt; BSDesignationDate#3
      [1781] =&gt; BSDesignationCode#4
      [1782] =&gt; BSDesignationDate#4
      [1783] =&gt; BSDesignationCode#5
      [1784] =&gt; BSDesignationDate#5
      [1785] =&gt; BSDesignationCode#6
      [1786] =&gt; BSDesignationDate#6
      [1787] =&gt; BSDesignationCode#7
      [1788] =&gt; BSDesignationDate#7
      [1789] =&gt; BSDesignationCode#8
      [1790] =&gt; BSDesignationDate#8
      [1791] =&gt; BSDesignationCode#9
      [1792] =&gt; BSDesignationDate#9
      [1793] =&gt; BSDesignationCode#10
      [1794] =&gt; BSDesignationDate#10
      [1795] =&gt; BSDesignationCode#11
      [1796] =&gt; BSDesignationDate#11
      [1797] =&gt; BSDesignationCode#12
      [1798] =&gt; BSDesignationDate#12
      [1799] =&gt; BSPrimaryFieldofBusiness
      [1800] =&gt; BSSecondaryFieldofBus1
      [1801] =&gt; BSSecondaryFieldofBus2
      [1802] =&gt; BSSecondaryFieldofBus3
      [1803] =&gt; User Title
      [1804] =&gt; BSPointOfEntry
      [1805] =&gt; BSEMailAddress
      [1806] =&gt; BSMLSNumber
      [1807] =&gt; Altaira Multi-Login Flag YN
      [1808] =&gt; BSStopFaxCode
      [1809] =&gt; Agent Extension
      [1810] =&gt; BSReinstatementCode
      [1811] =&gt; BSReinstatementDate
      [1812] =&gt; BSNARDuesPaid
      [1813] =&gt; BSStateDuesPaid
      [1814] =&gt; Board Old
      [1815] =&gt; Address 2
      [1816] =&gt; Address 3
      [1817] =&gt; Entry Date
      [1818] =&gt; First Name
      [1819] =&gt; Personal Fax
      [1820] =&gt; Last Name
      [1821] =&gt; Last Transaction Code
      [1822] =&gt; Last Transaction Date
      [1823] =&gt; Office Code
      [1824] =&gt; Password
      [1825] =&gt; Rdfsetdate
      [1826] =&gt; Record Delete Flag
      [1827] =&gt; Roster Flag (Old)
      [1828] =&gt; Primary User Class
      [1829] =&gt; Member Code
      [1830] =&gt; Agent ID
      [1831] =&gt; User Title (Old)
      [1832] =&gt; Home Phone 
      [1833] =&gt; Postal Code
      [2310] =&gt; RegBoard
      [2414] =&gt; User Full Name
      [2415] =&gt; User Company Name
      [2416] =&gt; User Address1
      [2417] =&gt; User Address2
      [2418] =&gt; User City
      [2419] =&gt; User State
      [2420] =&gt; User Zip
      [2421] =&gt; User Work Phone
      [2422] =&gt; User Cell Phone
      [2423] =&gt; User Pager-PIN
      [2424] =&gt; User Fax
      [2425] =&gt; User 800 Phone
      [2426] =&gt; User Primary Email
      [2427] =&gt; User Cell Email
      [2428] =&gt; User Web URL
      [2429] =&gt; User Email Signature
      [2468] =&gt; MLX Type
      [2469] =&gt; SecondaryBoardID
      [2473] =&gt; License Type
      [2513] =&gt; MDCAuditLevel
      [2514] =&gt; AgentFullName
      [2515] =&gt; ProNDREmailAddress
      [2530] =&gt; SuspensionType
      [2531] =&gt; SuspensionDate
      [2555] =&gt; PriviledgedSSOUser
      [2556] =&gt; Designation
      [2557] =&gt; EmailSignature
      [2572] =&gt; FirmCode
      [2573] =&gt; FirmName
      [2585] =&gt; DrivingLatitude
      [2586] =&gt; DrivingLongitude
      [2598] =&gt; AgentLicense
      [2689] =&gt; ListingServiceNameAbbrev
      [2692] =&gt; Member CREA ID
      [2699] =&gt; LastLoginDate
  )
  </code></pre>
  
  <p>I must specifiy that this exact request works for pulling out properties :</p>
  
  <pre><code>$search = $rets-&gt;SearchQuery("Property",1,"(105=2012-01-01+)");
  while ($listing = $rets-&gt;FetchRow($search)) {
      echo print_r($listing);
  }
  </code></pre>