database error when using DISTINCT and ORDER BY

Does this not work?

Code:

$this->db->select('distinct message_user_id, message_user_name, message_id');