title: Joomla using DISTINCT in mySQL call
body: <p>I'm trying to use DISTINCT to get a list of cities from a column in my DB.</p>
  
  <pre><code>function cityData() {
      $db =&amp; JFactory::getDBO();
      $query = "SELECT DISTINCT MSTCITY FROM " . $db-&gt;nameQuote('#__mls') . " ORDER BY MSTCITY;";
      $db-&gt;setQuery($query);
      $tbl = $db-&gt;loadObjectList();
      return $tbl;
  }
  </code></pre>
  
  <p>Is there something akin to <code>loadObjectList()</code> that I can use ?</p>