Joomla在mySQL调用中使用DISTINCT

Question

I'm trying to use DISTINCT to get a list of cities from a column in my DB.

function cityData() {
    $db =& JFactory::getDBO();
    $query = "SELECT DISTINCT MSTCITY FROM " . $db->nameQuote('#__mls') . " ORDER BY MSTCITY;";
    $db->setQuery($query);
    $tbl = $db->loadObjectList();
    return $tbl;
}

Is there something akin to loadObjectList() that I can use ?

Answer 1

There are several options available to get data using database object. You can check this link- http://docs.joomla.org/Accessing_the_database_using_JDatabase/1.5

In your case you can use loadResultArray() in place of loadObjectList.It'll return list of cities as values of an array.