i have already used ''collection_select'' select helper for drop down box. it works properly and retrieve data from database(mysql).Bt I did''t not select any particular data from database and did''t fire the quary for drop down I use this syntax <%= collection_select(:practices, :id, @cfohomes, :id, :cfod_suniversity, options ={:prompt => "-Select a University"}, :class =>"practices") %> here cfod_suniversity is a attribute of my database plz provide a simple code to insert the selected item into database -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---