i needed for one of my projects a function to SELECT DISTINCT types form the database, so i added following function public function getDistinctTypes() { $con = Propel::getConnection(self::DATABASE_NAME); $sql = "SELECT DISTINCT type FROM ".self::TABLE_NAME." ORDER BY type ASC"; $rs = $con->executeQuery($sql, ResultSet::FETCHMODE_NUM); $result = array(); while ($rs->next()) { $result[] = $rs->getS