'How to have 'other' as an option in dropdown list?

i want to have a dropdown list which the list is retrieved from the database. the list will have 'other' as an option at the bottom of the list. How can do that?

currently this is my code but it not working

SELECT id, contactName 
FROM ( 
       SELECT id as id, c_contactName as contactName 
       FROM app_fd_crm_cust_cntct 
       UNION
       SELECT 'others' as id, 'Others' as contactName
) a
ORDER BY CASE 
            WHEN id <> 'others' THEN 0 
            ELSE 1 
         END
         , contactName asc
phpmysql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions