How to populate combobox from db?

Rails
1

Hello Friends,
I am a newbie in ROR.
Can you plz tell me how to populate the combobox with data from db?If
you could give both the view and controller part it would be helpful.I
am using a Mysql database

2

or you can use this in your view:

<%= collection_select(:video, :category_id, Category.all, :id, :name)
%>

Category.all can be called in your controller and passed to the form
tag as instance variable… something like

@categories = Category.all

then

<%= collection_select(:video, :category_id, @categories, :id, :name)
%>

3

on Controller

def index
@categories = Category.find(:all)
end

on View

<%= select(“post”, “category_id”, @categories.collect {|p| [ p.name,
p.id ]
}, {:include_blank => ‘None’})%>

4

Bala wrote:

on Controller

def index
@categories = Category.find(:all)
end

on View

<%= select(“post”, “category_id”, @categories.collect {|p| [ p.name,
p.id ]
}, {:include_blank => ‘None’})%>

Thank you so much…Ur code exactly worked for me…

5

welcome