sort the collection in the index.rhtml

Hi,

i am using rails 1.2.6 please forgive me as this application is live and i could not find the time to move it to rails 2.0

i have a index.rhtml for items

item has 3 attributes other than id, they are name, category and size

current status =>

inside the index.rhtml

i obviously already display my data as below:

name category size a mugs L aa mugs M abc towels L bb toothpaste S

what i need now is an additional drop down list that will contain all possible categories of the products

so if i choose let say, mugs from the drop down list the whole page can either using ajax to refresh the list to contain just mugs or do a refresh of the page.

this drop down not only needs to include teh varioous categories but also the word 'All' so that if the user chooses All , the list will again display all items in database.

Can someone please enlighten me on how to do this?

Thank you.

You mean to say you want to create a dynamic drop down in which if a category is changed then the other drop down should be filled accordingly??

Hi,

I meant that i only want 1 drop down.

depending on what i chose in that drop down list, i will display items based on drop down.

that drop down will include all possible categories as well as teh value "All"

eg:

if i have just 5 items,

item 1 category is mugs item 2 category is mugs item 3 category is towels item 4 category is towels item 5 category is cups

if i chose all in that drop down, the page will display items 1 - 5 if i chose mugs in the drop down, the page will display items 1 - 2 if i chose towels in the drop down, the page will display items 3 - 4 if i chose cups in the drop down, the page will display items 5

Please advise.

Thank you.